Re: [GENERAL] pg_dump and copy command

2006-04-05 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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 Velev

Re: [GENERAL] pg_dump and copy command

2006-04-05 Thread Tom Lane
"Chris Velevitch" <[EMAIL PROTECTED]> 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 scr

[GENERAL] pg_dump and copy command

2006-04-05 Thread Chris Velevitch
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_i