Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with COPY FROM - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with COPY FROM
Date
Msg-id 5667.1054148414@sss.pgh.pa.us
Whole thread Raw
In response to Problem with COPY FROM  ("Jay O'Connor" <joconnor@cybermesa.com>)
Responses Re: Problem with COPY FROM  ("Jay O'Connor" <joconnor@cybermesa.com>)
List pgsql-general
Tree view 
"Jay O'Connor" <joconnor@cybermesa.com> writes:
> So what is the proper way of ending a line in a file you expect to feed in
> to "COPY FROM"...

Newline (\n).  Don't put a tab after the last column, either.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problem delete record error:heap_mark4update
Next
From: "Jay O'Connor"
Date:
Subject: Re: Problem with COPY FROM