ignore duplicate key while using COPY?

From: Yan Chunlu <springrider(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: ignore duplicate key while using COPY?
Date: 2011-12-19 06:54:21
Message-ID: CAOA66tFDp+u+x_x+S4WhhxLNCczU=O85M8LcMSqvB+5e_HANdw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Markus 2011-12-19 06:56:21 Re: How to make a non-removable row in a table?
Previous Message Капралов Александр 2011-12-19 06:43:58 How to make a non-removable row in a table?