Re: COPY questions

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Bill Todd <pg(at)dbginc(dot)com>
Subject: Re: COPY questions
Date: 2009-02-18 20:14:47
Message-ID: 200902181214.47559.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)comcast(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-02-18 20:22:20 Re: Debugging custom type libraries
Previous Message Brent Wood 2009-02-18 20:12:39 Re: Appending \o output instead of overwriting the output file