Re: pg_dump and copy command

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and copy command
Date: 2006-04-05 14:03:06
Message-ID: 27451.1144245786@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com> writes:
> I've dumped a 7.4.5 database using pg_dump and when I used the result
> via pgAdmin v1.4.2 on a remote 7.4.11 server, I get an error:-

> ERROR: syntax error at or near "45183" at character 5848

Does pgAdmin promise that it can read pg_dump scripts? They're intended
to be fed into psql. The symptom sounds like pgAdmin is getting
confused about where the command boundaries are, which is fairly easy to
do in a mixed SQL-and-COPY-data script.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Emi Lu 2006-04-05 14:26:02 using initcap() for the French charater
Previous Message Martijn van Oosterhout 2006-04-05 13:54:19 Re: SQL ASCII encoding