Re: copy error

Michael Fuhr <mike@fuhr.org> writes:
> I'd guess that there's a carriage return at the end of line 1.

Looks like that to me too.

> You might need to run your data through a filter before importing
> it into PostgreSQL.  Some systems have a dos2unix program; you could
> also use tr, sed, perl, awk, etc. to strip trailing carriage returns.

Alternatively, update to PG 7.4 or later.  Since 7.4 COPY will attempt
to Do The Right Thing with files containing Windows-style newlines.

            regards, tom lane