SQL · Writing data

merge

Standard SQL for conditional insert, update and delete. PostgreSQL 15+ supports it.

sqlRunnable example sql course

Syntax

merge into target using source on …

Example

Open in the lab

-- PostgreSQL 15+
-- MERGE INTO lessons t USING staging s ON t.id = s.id
-- WHEN MATCHED THEN UPDATE SET title = s.title
-- WHEN NOT MATCHED THEN INSERT (id, title) VALUES (s.id, s.title);

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

merge

Example

More in this group

Learn this in the course