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
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
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
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
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
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).