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

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 ? Anybody give me some suggestion?

---

张晓博   研发二部

北京人大金仓信息技术股份有限公司

地址：北京市海淀区上地西路八号院上地科技大厦4号楼501

邮编：100085

电话：(010) 5885 1118 - 8450

手机：15311394463

邮箱：xbzhang@kingbase.com.cn