Skip to content

Glossary: PostgreSQL for Developers

ON CONFLICT

Also written: ON CONFLICT DO NOTHING

The clause that turns an INSERT into an upsert. DO UPDATE changes the existing row, and DO NOTHING skips the new one.

Where the book teaches it

Related terms

upsertEXCLUDED