[GENERAL] INSERT and ON CONFLICT

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема [GENERAL] INSERT and ON CONFLICT
Дата
Msg-id alpine.LNX.2.11.1703100930000.26081@localhost
обсуждение исходный текст
Ответы Re: [GENERAL] INSERT and ON CONFLICT
Список pgsql-general
   I'm filling a table with rows and have the first batch successfully
inserted. When I add more rows there may be some that already exist in the
table and I would prefer that they be ignored and the insert process
continue.

   The syntax page for INSERT suggests that ON CONFLICT DO NOTHING is exactly
what I want to include in the command. Have I correctly interpreted what the
DO NOTHING option does when a row to be inserted already is present in the
table?

Rich


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