UPSERT

Difficulty: Beginner

Question

What is an UPSERT?

Answer

An operation that either Inserts a row or, if a unique key conflict occurs, Updates the existing row instead (e.g., `INSERT ... ON CONFLICT DO UPDATE`).

Concepts covered

Insert, Update, Conflicts