Tom, I have checked the dump file with hexedit and find that the lines end with '0A' hex. Only one character.
What is strange is that I have multiple tables, some of them are going in fine. Ted -- Tom Lane <[EMAIL PROTECTED]> wrote: > 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 __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus – Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ---------------------------(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
