Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY questions - Mailing list pgsql-general

From Bill Todd
Subject Re: COPY questions
Date
Msg-id 499C7216.3020606@dbginc.com
Whole thread Raw
In response to Re: COPY questions  (Adrian Klaver <aklaver@comcast.net>)
Responses Re: COPY questions
List pgsql-general
Tree view
Adrian Klaver wrote: 
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.
Thanks for the suggestion but pgloader appears to be a Linux only solution and my environment is Windows. The other problem is that there is no documentation that I could find (other than a PDF made from slides).

Bill

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: When adding millions of rows at once, getting out of disk space errors
Next
From: Scott Marlowe
Date:
Subject: Re: When adding millions of rows at once, getting out of disk space errors