[GENERAL] INSERT and ON CONFLICT - Mailing list pgsql-general

From Rich Shepard
Subject [GENERAL] INSERT and ON CONFLICT
Date
Msg-id alpine.LNX.2.11.1703100930000.26081@localhost
Whole thread Raw
Responses Re: [GENERAL] INSERT and ON CONFLICT
List 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 by date:

Previous
From: Rich Shepard
Date:
Subject: [GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Upgradede -9.6.1 to -9.6.2; postmaster will not start