SQLize | PHPize | SQLtest

CREATE TABLE IF NOT EXISTS MyTable ( ColumnID1 integer NOT NULL, ColumnID2 integer NOT NULL, ColumnName character varying(1000), CONSTRAINT "MyTable_pkey" PRIMARY KEY (ColumnID1, ColumnID2), CONSTRAINT "MyTable-ColumnID1-ColumnName-Unique-Key" UNIQUE (ColumnID1, ColumnName) DEFERRABLE INITIALLY DEFERRED ); insert into MyTable values (1, 1, 'a'), (1, 2, 'b'); insert into MyTable (ColumnID1, ColumnID2, ColumnName) values (1, 1, 'c'), (1, 2, 'd') on conflict (ColumnID1, ColumnID2) do update set ColumnName = EXCLUDED.ColumnName; insert into MyTable (ColumnID1, ColumnID2, ColumnName) values (1, 1, 'd'), (1, 2, 'c') on conflict (ColumnID1, ColumnID2) do update set ColumnName = EXCLUDED.ColumnName; select * from MyTable;