SQL · Writing data

upsert

Inserts or updates when a unique constraint is violated. PostgreSQL and SQLite support ON CONFLICT.

sqlRunnable example sql course

Syntax

insert … on conflict … do update

Example

Open in the lab

CREATE TEMP TABLE notes (slug TEXT PRIMARY KEY, body TEXT);
INSERT INTO notes VALUES ('css', 'first')
ON CONFLICT (slug) DO UPDATE SET body = excluded.body;
INSERT INTO notes VALUES ('css', 'second')
ON CONFLICT (slug) DO UPDATE SET body = excluded.body;
SELECT * FROM notes;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

upsert

Example

More in this group

Learn this in the course