----- "Le-shin Wu" <leshin@xxxxxxxxx> 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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
