Request a Demo
Home   >   mailing lists

Re: ignore duplicate key while using COPY? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: ignore duplicate key while using COPY?
Date
Msg-id 201112190619.22108.adrian.klaver@gmail.com
Whole thread Raw
In response to ignore duplicate key while using COPY?  (Yan Chunlu <springrider@gmail.com>)
Responses Re: ignore duplicate key while using COPY?
List pgsql-general
Tree view 
On Sunday, December 18, 2011 10:54:21 pm Yan Chunlu wrote:
> I am using COPY public.table_name FROM STDIN  to import data.  it is
> very efficient, but if there's any duplicate key exists, the whole
> procedure has been stopped.  is there anyway to around this?
>
> why does not postgresql just give a warning and continue the copy?

Take a look at pgloader:
http://pgfoundry.org/projects/pgloader/

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: "Marc Mamin"
Date:
Subject: consecutive analyze calls with different column lists.
Next
From: David Johnston
Date:
Subject: Fwd: consecutive analyze calls with different column lists.