[GENERAL] COPY questions

2009-02-18 Thread Bill Todd
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

Re: [GENERAL] COPY questions

2009-02-18 Thread Jeff Davis
On Wed, 2009-02-18 at 11:56 -0700, Bill Todd wrote: If the COPY command fails does it identify the offending row? Yes, it tries to identify the failing row in the error message. After reading the manual and the wiki I assume that there is no way to tell copy to start with the Nth record in

Re: [GENERAL] COPY questions

2009-02-18 Thread Adrian Klaver
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

Re: [GENERAL] COPY questions

2009-02-18 Thread Bill Todd
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

Re: [GENERAL] COPY questions

2009-02-18 Thread Tony Caduto
Bill Todd wrote: 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 Bill, pgloader is a Python app, It should work on win32

Re: [GENERAL] COPY questions

2009-02-18 Thread Adrian Klaver
On Wednesday 18 February 2009 2:00:19 pm Tony Caduto wrote: Bill Todd wrote: 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).