#upsert
2 snippets tagged with #upsert
sqlintermediate
UPSERT with ON CONFLICT
Insert or update rows atomically using PostgreSQL ON CONFLICT clause with partial indexes and conditions.
#upsert#postgresql
sqlintermediate
SQL MERGE (Standard Upsert)
Use the SQL MERGE statement for atomic insert-or-update operations with matched/not-matched clauses.
#merge#upsert