Updating rows ​

UPDATE changes matching rows immediately; an upsert combines insertion with a conflict-driven update. Both validate target types and constraints and follow transaction rules.

Read Update data for a worked example and the links to the exact statement syntax.