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  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: "Patrick Hatcher"
Дата:
Сообщение: Re: Cant group by non integer - ms access - odbc
Следующее
От: "Devinder K Rajput"
Дата:
Сообщение: Reserved Word