Re: import data from openoffice Calc - Mailing list pgsql-general

From Adrian Klaver
Subject Re: import data from openoffice Calc
Date
Msg-id 1973691762.181011259781461155.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net
Whole thread Raw
In response to Re: import data from openoffice Calc  (Le-shin Wu <leshin@gmail.com>)
List pgsql-general
----- "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


pgsql-general by date:

Previous
From: Israel Brewster
Date:
Subject: Re: Build universal binary on Mac OS X 10.6?
Next
From: akp geek
Date:
Subject: Re: Auto Vaccum