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@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
