Peralta Miguel-MPERALT1 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
