Re: Bad Date field

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