thanks a lot! On Mon, Dec 19, 2011 at 10:19 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote:
> 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.kla...@gmail.com >