Skip site navigation (1) Skip section navigation (2)

Re: Problems with \copy

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Klaudia Walter <kw243(at)cam(dot)ac(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problems with \copy
Date: 2002-04-25 17:02:47
Message-ID: 2486.1019754167@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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 LaneDate: 2002-04-25 17:14:27
Subject: Re: Shell Script Execution
Previous:From: William MeloneyDate: 2002-04-25 17:02:15
Subject: Persistent vs. "Normal"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group