Re: Problems with \copy - Mailing list pgsql-novice

From Tom Lane
Subject Re: Problems with \copy
Date
Msg-id 2486.1019754167@sss.pgh.pa.us
Whole thread Raw
In response to Problems with \copy  (Klaudia Walter <kw243@cam.ac.uk>)
List pgsql-novice
Klaudia Walter <kw243@cam.ac.uk> writes:
> I am having problems loading files with \copy. It seems that there are
> problems with the newline character.

COPY insists on lines being ended by \n, not \r (Mac convention) nor yet
\r\n (Windows conventions).  Not sure which of these you've got, but
evidently it's not the right one ...

There are plans afoot to make COPY more forgiving, but since there are
backwards-compatibility issues it will take a few versions before we can
complete the changeover.

            regards, tom lane

pgsql-novice by date:

Previous
From: William Meloney
Date:
Subject: Persistent vs. "Normal"
Next
From: Tom Lane
Date:
Subject: Re: Shell Script Execution