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;
原文：https://www.cnblogs.com/xr210/p/13581600.html