Re: COPY questions

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