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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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