skipping records with duplicate key during COPY

Поиск
Список
Период
Сортировка
От Devinder K Rajput
Тема skipping records with duplicate key during COPY
Дата
Msg-id OFA585A509.CC7CFFD7-ON86256C93.0068E08F@ipaper.com
обсуждение исходный текст
Ответы Re: skipping records with duplicate key during COPY
Список pgsql-novice

Hi,
        I am using COPY command to load a data table.  When I try to insert a record with a duplicate key, I get the error message "cannot insert a duplicate key into unique index" and no data is loaded into the table.  I know that this is the way the COPY command works.  Now, is there a way in which I can load a table and if duplicate records do come up, write them to an error file, but still load the other good records into the table?  *I think* one of accomplishing this is by performing inserts of individual records, but that would be very slow.  any suggestions?

TIA,

Devinder

В списке pgsql-novice по дате отправления: