Skip site navigation (1) Skip section navigation (2)

'invalid command \N' during restore from pg_dump

From: kevin kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: 'invalid command \N' during restore from pg_dump
Date: 2008-10-17 21:11:24
Message-ID: B8A008D3-9F09-49C6-B413-86C41EEB4969@kevinkempterllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all;

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 ?)

Thoughts?

Thanks in advance

Responses

pgsql-admin by date

Next:From: Jan-Peter SeifertDate: 2008-10-17 21:20:55
Subject: Re: 'invalid command \N' during restore from pg_dump
Previous:From: Kevin GrittnerDate: 2008-10-17 20:09:09
Subject: 8.3.4 PITR recovery questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group