upsert

WITH upsert AS ( UPDATE target SET col1 = s.col1, col2 = s.col2, … FROM source s WHERE s.key = target.key RETURNING s.*)INSERT INTO target ( … )SELECT key, col1, …