Re: ignore duplicate key while using COPY?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Yan Chunlu <springrider(at)gmail(dot)com>
Subject: Re: ignore duplicate key while using COPY?
Date: 2011-12-19 14:19:21
Message-ID: 201112190619.22108.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-12-19 14:23:54 Fwd: consecutive analyze calls with different column lists.
Previous Message Marc Mamin 2011-12-19 13:04:32 consecutive analyze calls with different column lists.