On Mon, Jan 22, 2001 at 07:04:51PM +0530, Anand Raman wrote:
> hi guys
> While trying to isnert data into a table using the \copy i am getting a
> error which states Bad timestamp representation..
> I am not sure why it is occuring..
> Can some one point out what this mistake is ..
> My datestyle is set to
> "DateStyle is ISO with US (NonEuropean) conventions"
>
> arttoday=# \copy artists from STDIN using delimiters '|' with null as '||';
> 2|1001|2001-01-22 13:45:32+05:30|||A S Chitarak||||||||||||
> \.
> ERROR: copy: line 1, Bad timestamp external representation ''
> PQendcopy: resetting connection
>
> Thanx for ur help
> Anand
What does just
\copy artists from STDIN using delimiters '|';
do for you?
Cheers,
Patrick
