Skip site navigation (1) Skip section navigation (2)

resend: Trouble with pg_dump in 7.3.4

From: Frank Voellmann <fvoellma(at)cisco(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: resend: Trouble with pg_dump in 7.3.4
Date: 2004-07-14 19:47:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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#  \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?


pgsql-novice by date

Next:From: Bruce MomjianDate: 2004-07-14 20:06:47
Subject: Re: resend: Trouble with pg_dump in 7.3.4
Previous:From: Frank VoellmannDate: 2004-07-14 19:39:54
Subject: Trouble with pg_dump in 7.3.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group