Re: [GENERAL] Copy From with "null" data

2003-08-16 Thread Tom Lane
"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

[GENERAL] Copy From with "null" data

2003-08-16 Thread James Moe
-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