Inserts a row or updates it if a conflict on a unique key occurs. A clean pattern for syncing external data without duplicate errors (PostgreSQL syntax).
1INSERT INTO products (id, name, price)
2VALUES (42, 'Widget Pro', 19.99)
3ON CONFLICT (id) DO UPDATE SET
4 name = EXCLUDED.name,
5 price = EXCLUDED.price;