----- "Le-shin Wu" <leshin@gmail.com> wrote:
> HI Adrian,
>
> Thanks for pointing out the reporting bug information about my
> problem. I have tried your suggestion and it works great. But this
> approach can only solve one part of my problem, because I also need to
> open an existing db table through Clac, edit some tuples, and then
> save it as a new table. For this case, I can not convert my original
> "date" data to text (because it will become an integer after
> converting as you mentioned). Thanks again.
>
>
> LW
>
Might be easier to use the CREATE TABLE AS command:
http://www.postgresql.org/docs/8.4/interactive/sql-createtableas.html
Adrian Klaver
aklaver@comcast.net