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