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

From John Smith
Subject mass import to table with unique index
Date
Msg-id 20030129230016.44423.qmail@web40701.mail.yahoo.com
Whole thread Raw
Responses Re: mass import to table with unique index
List 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

pgsql-general by date:

Previous
From: "Glen Parker"
Date:
Subject: Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)
Next
From: "Williams, Travis L, NPONS"
Date:
Subject: Re: Perl DBI and placeheld values