[acarl005]

Actually standard SQL does specify a MERGE command (which lets you implement an upsert) and it's implemented in Postgres

[password4321]

MERGE debuted in PostgreSQL 15 fairly recently, and has some caveats.

https://news.ycombinator.com/item?id=33236780