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