Klaudia Walter <kw243(at)cam(dot)ac(dot)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
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2002-04-25 17:14:27|
|Subject: Re: Shell Script Execution |
|Previous:||From: William Meloney||Date: 2002-04-25 17:02:15|
|Subject: Persistent vs. "Normal"|