UPSERT (ON CONFLICT)

Insert or update if exists (PostgreSQL)

Mutation

SQL

INSERT INTO users (email, name)
VALUES ('alice@example.com', 'Alice')
ON CONFLICT (email)
DO UPDATE SET name = EXCLUDED.name;

What each clause does

ON CONFLICT (email) detects unique violations. DO UPDATE SET applies changes when a conflict occurs (PostgreSQL syntax).

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT All Rows SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function LIMIT & OFFSET