Postgres Pro
Downloads
Home   >   mailing lists

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

From Le-shin Wu
Subject Re: import data from openoffice Calc
Date
Msg-id d44f0d640912020825g72d67885t7f948c0a247289f6@mail.gmail.com
Whole thread Raw
In response to Re: import data from openoffice Calc  (Adrian Klaver <aklaver@comcast.net>)
Responses Re: import data from openoffice Calc  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view
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 


On Tue, Dec 1, 2009 at 6:38 PM, Adrian Klaver <aklaver@comcast.net> wrote:

----- "Le-shin Wu" <leshin@gmail.com> wrote:

> Hi Adrian,
>
> Thanks for your information. I think your suggestion will be my last
> approach, if I really can not find a way to solve my problem.
> Actually, I tried to format the cells type (the "date" column in my
> sheet) in Calc as "Date" before I copy and past, but somehow it works
> for only once. This also confused me. Thanks again.
>
> LW
>

Once the column is formatted as "Date" the underlying value will be the integer value. I did a little test and found the following. If I preformatted a column as "Text" and then entered date strings for example "12/01/09" it stayed a string when cut and pasted. If I just started entering a date string in a column the column would become a "Date" column. Changing the formatting to "Text" would change the date strings "12/01/09" to the underlying integer 40147. Any new date strings entered however would stay as "12/01/09". Hope this helps.


Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Roles with passwords; SET ROLE ... WITH PASSWORD ?
Next
From: River Tarnell
Date:
Subject: Re: Postgres performance on Veritas VxVM