Insert If Missing, Update If Present
PostgreSQL writes an UPSERT as INSERT ... ON CONFLICT. If the chosen key does not exist, it inserts; if it exists, DO UPDATE or DO NOTHING handles the conflict.
Which PostgreSQL clause updates on conflict?
PostgreSQL writes an UPSERT as INSERT ... ON CONFLICT. If the chosen key does not exist, it inserts; if it exists, DO UPDATE or DO NOTHING handles the conflict.
Which PostgreSQL clause updates on conflict?