From: | Frank Voellmann <fvoellma(at)cisco(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Trouble with pg_dump in 7.3.4 |
Date: | 2004-07-14 19:39:54 |
Message-ID: | 4.3.2.7.2.20040714151725.02b1d568@funnel.cisco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm using the following to backup a table from a database
pg_dump --table=tableName --clean --format p dbName
The file produced has all lines preceded by a space. Only the COPY such as
this ...
COPY rr_config (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o) FROM stdin;
69 2 \N \N mydevice ahash 1 \N \N
mydevice#10.86.209.205 \N \N \N 68 63
\.
seems to care. I get these errors:
ERROR: copy: line 2, Bad numeric input format ' '
lost synchronization with server, resetting connection
manually removing the space before the "\." fixes the problem.
Is there a workaround?
Thanks,
Frank
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Voellmann | 2004-07-14 19:47:27 | resend: Trouble with pg_dump in 7.3.4 |
Previous Message | Lynna Landstreet | 2004-07-14 19:36:08 | Re: Seaching with and without diacritical marks |