> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane > Sent: 05 April 2006 15:03 > To: Chris Velevitch > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: [GENERAL] pg_dump and copy command > > "Chris Velevitch" <chris.velevitch@xxxxxxxxx> 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. pgAdmin PQexec's its input, therefore cannot handle the copy from stdin in a pg_dump script. It should work if you use INSERTs instead of COPY though. Regards, Dave.
