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

body { line-height: 1.5; }p { margin-top: 0px; margin-bottom: 0px; }body { font-size: 10.5pt; font-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }

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 ?

-- 
Vik

On 05/29/2014 12: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 ?

Use an external program like:

pgloader

http://pgloader.tapoueh.org/

or

pg_bulkload

http://pgbulkload.projects.pgfoundry.org/pg_bulkload.html

> 邮箱：xbzhang@kingbase.com.cn <mailto:xbzhang@kingbase.com.cn>
>


--
Adrian Klaver
adrian.klaver@aklaver.com