| From: | Bill Todd <pg(at)dbginc(dot)com> |
|---|---|
| To: | Adrian Klaver <aklaver(at)comcast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: COPY questions |
| Date: | 2009-02-18 20:39:50 |
| Message-ID: | 499C7216.3020606@dbginc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-02-18 20:54:00 | Re: When adding millions of rows at once, getting out of disk space errors |
| Previous Message | Tom Lane | 2009-02-18 20:36:13 | Re: Appending \o output instead of overwriting the output file |