Postgres Pro
Downloads
Home   >   mailing lists

Thread: problem with copy

problem with copy

From
Anand Raman
Date:
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

Re: problem with copy

From
Tom Lane
Date:
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

Re: problem with copy

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

On Mon, Jan 22, 2001 at 10:46:34AM -0500, Tom Lane wrote:
>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

Re: problem with copy

From
Patrick Welche
Date:
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