Peralta Miguel-MPERALT1 <Miguel(dot)Peralta(at)motorola(dot)com> writes:
> COPY release_data FROM '/home/mperalta/release_data' USING DELIMITERS '|'
> When I issue this command, the response afte a while is the following:
> ERROR; Bad date external representation '9'
> The external file is rather large and I've tried finding this bad date
> manually with no success.
How old is your Postgres? The last several releases include line
numbers when complaining about COPY problems.
In the meantime, I like the other person's suggestion about importing
into a temp table and then working with the temp table to clean up
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Stephan Szabo||Date: 2001-11-29 18:39:41|
|Subject: Re: Vaccum|
|Previous:||From: bangh||Date: 2001-11-29 18:32:04|
|Subject: Re: table test|