How to implement the skip errors for copy from ?

From: xbzhang <xbzhang(at)kingbase(dot)com(dot)cn>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: How to implement the skip errors for copy from ?
Date: 2014-06-16 09:46:38
Message-ID: 2014061617463628926328@kingbase.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I want to?implement the skip errors for copy from,lik as :create table A (c int primary key);copy A from stdin;112\.
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 resultwill 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(at)kingbase(dot)com(dot)cn

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2014-06-16 09:54:22 Re: How to implement the skip errors for copy from ?
Previous Message Christoph Berg 2014-06-16 08:55:09 Re: postgresql.auto.conf read from wrong directory