From: | Bricklen <bricklen-rem(at)yahoo(dot)comz> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: COPY error handling |
Date: | 2004-06-07 14:38:20 |
Message-ID: | w5%wc.59912$OI5.14807@edtnps84 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bruno Wolff III wrote:
> On Fri, Jun 04, 2004 at 14:11:19 +0000,
> Bricklen <bricklen-rem(at)yahoo(dot)comz> wrote:
>
>>Hi, I'm not sure if this is the correct group for this question, but
>>I'll post it hoping that it is.
>>I'm loading several ~15 million row files into a table using the COPY
>>command. Apparently one of the rows, about 6 million in, has an invalid
>>entry. This is causing the COPY command to fail, so my question is this:
>>Is there any way to skip invalid rows? Or send them to a separate log
>>file etc to go through later?
>>I've gone through the docs, but I didn't see anything specific to this.
>>Any information, links, or hints are greatly appreciated.
>
>
> Currently there isn't a builtin way to do this. You can pass the data
> through a filter script that removes rows that are not in a proper format.
>
Thanks for the clarification!
Cheers,
Bricklen
From | Date | Subject | |
---|---|---|---|
Next Message | Jernej Kos | 2004-06-07 14:39:23 | Index question |
Previous Message | Együd Csaba | 2004-06-07 14:31:51 | Re: pg_dump, bytea, dump order questions |