problem with copy

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

Anand Raman <araman@india-today.com> writes:

arttoday=# \copy artists from STDIN using delimiters '|' with null as '||';

Er, don't you mean "with null as ''"?

The above-given command will never think any input column is a null,
since it won't parse '||' as a column value in the first place.

regards, tom lane

thanx ton
I realized this a few minutes after i posted to the list..
Thanks
Anand