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