mass import to table with unique index

From: John Smith <john_smith_45678(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: mass import to table with unique index
Date: 2003-01-29 23:00:16
Message-ID: 20030129230016.44423.qmail@web40701.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is there a way to mass import (like COPY, INSERT INTO ... SELECT ...) data into an existing table with existing data that has a unique index?

Such as importing data with SSNs, and there's a unique index on the SSN column. MySQL has an 'IGNORE' option for mass imports. Any way with PostgreSQL? Or only with an INSERT command for each record?

---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Williams, Travis L, NPONS 2003-01-29 23:00:24 Re: Perl DBI and placeheld values
Previous Message Glen Parker 2003-01-29 22:47:04 Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)