pg_dump and copy command

From: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump and copy command
Date: 2006-04-05 07:37:28
Message-ID: b0a3bf780604050037w6bdb3c82y42a7f2160127d613@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2006-04-05 08:05:01 Re: Cant find temp tables
Previous Message hubert depesz lubaczewski 2006-04-05 07:33:56 Re: database design questions