INSERT INTO distributors (did, dname)
    VALUES (5, ‘Gizmo Transglobal‘), (6, ‘Associated Computing, Inc‘)
    ON CONFLICT (did) DO UPDATE SET dname = EXCLUDED.dname;
 
INSERT INTO distributors (did, dname) VALUES (7, ‘Redline GmbH‘)
    ON CONFLICT (did) DO NOTHING;