From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: problem with copy |
Date: | 2001-01-22 13:45:51 |
Message-ID: | 20010122134551.A1638@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rajit Singh | 2001-01-22 15:21:15 | Silencing 'NOTICE' messages for PRIMARY KEY |
Previous Message | Alexander Jerusalem | 2001-01-22 13:42:22 | Re: Troubles with performances |