import ignoring duplicates

From: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>
To: pgsql-sql(at)postgresql(dot)org
Subject: import ignoring duplicates
Date: 2010-05-16 18:38:01
Message-ID: 4BF03B89.9020908@noaa.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am using psql's \copy command to add records to a database from a
file. The file has over 100,000 lines. Occasionally, there is a
duplicate, and the import ceases and an internal rollback is performed.
In other words, no data is imported even if the first error occurs near
the end of the file.

I am looking for an option/switch to tell psql (or the \copy command) to
skip over any duplicate key constraint viloations and continue to load
any data that doesn't violate a duplicate key constraint. Is there such
an option?

Mark

Attachment Content-Type Size
Mark_Fenbers.vcf text/x-vcard 402 bytes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tim Landscheidt 2010-05-17 00:32:00 Re: import ignoring duplicates
Previous Message Little, Douglas 2010-05-14 13:20:55 Re: Postgresql database