Peralta Miguel-MPERALT1 <Miguel.Peralta@motorola.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
the data.
regards, tom lane