How to UPSERT (MERGE, INSERT ... ON DUPLICATE UPDATE) in PostgreSQL?

How to UPSERT (MERGE, INSERT ... ON DUPLICATE UPDATE) in PostgreSQL?

postgresql insert-update upsert sql-merge

postgresql

Postgresql - Insert into where not exists using sqlalchemy's INSERT from SELECT

python postgresql sqlalchemy insert-update

postgresql

PostgreSQL create a new column with values conditioned on other columns

postgresql insert-update conditional-statements

postgresql

How can the INSERT ... ON CONFLICT (id) DO UPDATE... syntax be used with a sequence ID?

postgresql insert-update postgresql-9.5

postgresql

How does this SQL query to update a row if exists, or insert if not, work?

sql postgresql insert-update

postgresql

postgres: update a row on conflict insert and return old values

sql postgresql race-condition insert-update select-for-update

postgresql