resend: Trouble with pg_dump in 7.3.4 - Mailing list pgsql-novice

From Frank Voellmann
Subject resend: Trouble with pg_dump in 7.3.4
Date
Msg-id 4.3.2.7.2.20040714154615.02b195a8@funnel.cisco.com
Whole thread Raw
Responses Re: resend: Trouble with pg_dump in 7.3.4  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-novice
resend after joining list ...

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

pgsql-novice by date:

Previous
From: Lynna Landstreet
Date:
Subject: Re: Seaching with and without diacritical marks
Next
From: Bruce Momjian
Date:
Subject: Re: resend: Trouble with pg_dump in 7.3.4