mass import to table with unique index

Поиск
Список
Период
Сортировка
От John Smith
Тема mass import to table with unique index
Дата
Msg-id 20030129230016.44423.qmail@web40701.mail.yahoo.com
обсуждение исходный текст
Ответы Re: mass import to table with unique index  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список 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 по дате отправления:

Предыдущее
От: "Glen Parker"
Дата:
Сообщение: Dropping column silently kills multi-coumn index (was [ODBC] Error when accessing tables with deleted columns)
Следующее
От: "Williams, Travis L, NPONS"
Дата:
Сообщение: Re: Perl DBI and placeheld values