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
