Re: "Bad date external representation"

Lynna Landstreet <lynna@gallery44.org> writes:
> ERROR:  copy: line 1, Bad date external representation '9/19/2002'

That date as given is perfectly good:

regression=# select '9/19/2002'::date;
    date
------------
 2002-09-19
(1 row)

I suspect that the problem is whitespace that is not showing in your
representation of the error message.  A likely bet is that the dump
file has been Microsoft-ized, with newlines converted into carriage
return and linefeed ... the CR character will be taken as part of the
data by COPY.  Is the error message strangely formatted at all?

            regards, tom lane