On Oct 17, 2008, at 3:20 PM, Jan-Peter Seifert wrote:
Hello,
kevin kempter wrote:
I'm trying to run a restore from a pg_dump and I get loads of these:
invalid command \N
I see lots of \N char's in the data for some of the tables (NULL's ?)
Are you using pgAdmin's SQL-editor for restoring by any chance? It
throws errors - especially if the \N (NULL) is at the beginning of the
line. Use psql for restoring or try with activating the option to use
INSERT instead of COPY commands for creating dumps with pg_dump.
Peter
No, I'm doing it at the command line on a Redhat box (postgres version
8.2.5)
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
