Re: import data from openoffice Calc

----- "Le-shin Wu" <leshin(at)gmail(dot)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(at)comcast(dot)net