Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't import date using copy - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Can't import date using copy
Date
Msg-id 6681.972705808@sss.pgh.pa.us
Whole thread Raw
In response to Can't import date using copy  (Guy Fraser <guy@incentre.net>)
List pgsql-hackers
Tree view 
Guy Fraser <guy@incentre.net> writes:
> I have tried reformatting dates in many ways but every thing I have
> tried fails.

As a rule, COPY will interpret incoming dates according to the current
setting of the DATESTYLE variable.  It'd help if you explained the date
format you are trying to read and mentioned which datestyles you've
tried to use ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Gram.y patches for better parenthesis handling.
Next
From: Grant Finnemore
Date:
Subject: Re: [SQL] renaming columns... danger?