pg_dump and copy command
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
and the offending code is:-
COPY jobs (job_id, client_id, title, start_date, final_date,
approver1_id, approver2_id) FROM stdin;
45183 1634 Cataloguer 2001-04-18 2001-05-08 \N \N
45800 1634 Local Studies Librarian 2002-02-18 2002-11-12 \N \N
\.
Why is pg_dump generating offending code?
Are there any special options that I must use with pg_dump to make
this code executeable?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
"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
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: 05 April 2006 15:03
To: Chris Velevitch
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_dump and copy command"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.
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.
Import Notes
Resolved by subject fallback