Theodore Petrosky <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
