Re: COPY questions - Mailing list pgsql-general

From Adrian Klaver
Subject Re: COPY questions
Date
Msg-id 200902181214.47559.aklaver@comcast.net
Whole thread Raw
In response to COPY questions  (Bill Todd <pg@dbginc.com>)
Responses Re: COPY questions  (Bill Todd <pg@dbginc.com>)
List pgsql-general
On Wednesday 18 February 2009 10:56:45 am Bill Todd wrote:
> If the COPY command fails does it identify the offending row?
>
> After reading the manual and the wiki I assume that there is no way to
> tell copy to start with the Nth record in the input file. Is that
> correct? It seems like such an obvious feature I was surprised not to
> find it. Thanks.
>
> Bill

Take a look at:
http://pgfoundry.org/projects/pgloader/

It offers what you are looking for.

--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: "Brent Wood"
Date:
Subject: Re: Appending \o output instead of overwriting the output file
Next
From: Tom Lane
Date:
Subject: Re: Debugging custom type libraries