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