Insert a product or update it if it already exists (upsert).

Answer preview

INSERT … ON CONFLICT … DO UPDATE is an atomic upsert: PostgreSQL detects the unique violation and rewrites the row, with the rejected values available as the pseudo-table EXCLUDED.…