Re: How to implement the skip errors for copy from ?

[Vik Fearing <vik.fearing@xxxxxxxxxx>]

On 05/29/2014 09:25 AM, xbzhang wrote:

I want to implement the skip errors for copy from,lik as :

create table A (c int primary key);

copy A from stdin;

1

1

2

\.

copy will failed:

ERROR: duplicate key violates primary key constraint "CC_PKEY"
CONTEXT: COPY CC, line 2: "1"

I want skip the error, and continue to copy the reset of tuple. The result

will be that there are two rows in table A: 1 and 2.

how to implement that ?

Have a look at pgloader. http://pgloader.tapoueh.org/

-- 
Vik