Postgres - insert missing and ignore dups -

pg-insert-missing.sql

CREATE TABLE public.test (
	id int4 NOT NULL,
	"text" text NULL,
	CONSTRAINT test_pkey PRIMARY KEY (id)
);
insert into test (id, text) values (1, 'hey'), (2, 'ho') on conflict do nothing;
insert into test (id, text) values (2, 'hoo'), (3, 'whatever') on conflict do nothing;
-- result: 1/hey, 2/ho, 3/whatever inserted - perfect: minimum # statements, exactly what's wanted: just fill in missing