Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and copy command - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump and copy command
Date
Msg-id 27451.1144245786@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump and copy command  ("Chris Velevitch" <chris.velevitch@gmail.com>)
List pgsql-general
Tree view 
"Chris Velevitch" <chris.velevitch@gmail.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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: SQL ASCII encoding
Next
From: Emi Lu
Date:
Subject: using initcap() for the French charater