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 > 邮箱：[email protected] <mailto:[email protected]> > -- Adrian Klaver [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
