problem with copy

From: Anand Raman <araman(at)india-today(dot)com>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: problem with copy
Date: 2001-01-22 13:34:51
Message-ID: 20010122190451.B17158@india-today.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lémery 2001-01-22 13:39:47 Re: Troubles with performances
Previous Message Lincoln Yeoh 2001-01-22 13:33:25 Re: Troubles with performances