"James Moe" <[EMAIL PROTECTED]> writes:
> this bizarre error message is produced in psql:
> ": can't parse "ne 1, pg_atoi: error in "1
That's unrelated to your NULL issue. It looks like you have
Windows-style newlines (\r\n) in your data. COPY only likes
Unix-style newlines (\n). It thinks the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I am attempting to import data from a text file (tab-delimited) that has NULL fields
of the form "(NULL)". (The source dbms does not have DUMP command.) According to the
v7.3 docs (http://www.postgresql.org/docs/7.3/static/sql-copy.html):
n