From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | xbzhang <xbzhang(at)kingbase(dot)com(dot)cn>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to implement the skip errors for copy from ? |
Date: | 2014-05-29 13:29:21 |
Message-ID: | 53873631.9090603@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
or
pg_bulkload
http://pgbulkload.projects.pgfoundry.org/pg_bulkload.html
> 邮箱:xbzhang(at)kingbase(dot)com(dot)cn <mailto:xbzhang(at)kingbase(dot)com(dot)cn>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Mimiko | 2014-05-29 13:47:16 | relocation R_X86_64_32 against `.rodata' can not be used when making a shared object |
Previous Message | Vik Fearing | 2014-05-29 13:26:06 | Re: How to implement the skip errors for copy from ? |