Theodore Petrosky <tedpet5(at)yahoo(dot)com> writes:
> COPY "fcopenjobs" FROM stdin;
> If I copy and paste the lines (from the dump file)
> into psql one by one, it will input fine. However, If
> I cut and paste more that two lines, the input fails.
I'm wondering about newline representations, myself. Is it possible
that you've got CR or CR/LF newlines, and not LF newlines, in the
dump file? COPY presently only likes LF (Unix-style) newlines.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Theodore Petrosky||Date: 2002-11-25 00:41:25|
|Subject: Re: more information on OSX pg_dump problem |
|Previous:||From: Theodore Petrosky||Date: 2002-11-24 22:33:55|
|Subject: more information on OSX pg_dump problem|