Re: Bulk Load Ignore/Skip Feature

On Tue, Nov 13, 2007 at 08:50:36PM -0800, Willem Buitendyk wrote:
> Will Postgresql ever implement an ignore on error feature when bulk
> loading data?  Currently it is my understanding that any record that
> violates a unique constraint will cause the "copy from" command to
> halt execution instead of skipping over the violation and logging it
> - as is done in Oracle and DB2.
>
> Are there alternative ways of dealing with this scenario that won't
> consume as much time?
>
> Appreciate any help  - would love to migrate away from Oracle.

You might try pgloader. :)

http://pgfoundry.org/projects/pgloader/

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate