Re: Can't import date using copy

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Guy Fraser <guy(at)incentre(dot)net>
Cc: PostgreSQL Development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Can't import date using copy
Date: 2000-10-28 04:03:28
Message-ID: 6681.972705808@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Guy Fraser <guy(at)incentre(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2000-10-28 04:12:59 Re: Can't import date using copy
Previous Message Alex Pilosov 2000-10-28 03:57:14 Re: Re: [GENERAL] A rare error