Re: mass import to table with unique index - Mailing list pgsql-general

On Thu, 30 Jan 2003 01:41:51 -0800 (PST), John Smith
<john_smith_45678@yahoo.com> wrote:
>> I think that what the OP is looking for is the SQL*Server equivalent of
>> option IGNORE_DUP_KEY, where if you try to insert a record with that key
>> already included, it simply ignores that record.
>
>Exactly :)

John,  import into a temporary table and then

INSERT INTO original_table
SELECT DISTINCT ON (your, uniq, cols) *
  FROM temp_table t
 WHERE NOT EXISTS (
    SELECT * FROM original_table o
     WHERE o.your=t.your AND o.uniq=t.uniq AND o.cols=t.cols)
 ORDER BY your, uniq, cols, whatever;

HTH.
Servus
 Manfred