Postgres 9.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table foo(
  --id serial primary key,
  bar char,
  baz char,
  bat char,
  moo smallint,
  boo smallint,
  primary key (bar, baz, bat)
 );

insert into foo (bar, baz, bat, moo, boo)
values ('a', 'b', 'c', 1, 2), ('d', 'e', 'f', 3, 4);

INSERT 0 2


select *
from foo


bar
baz
bat
moo
boo


a
b
c
1
2

d
e
f
3
4



SELECT 2


insert into foo (bar, baz, bat, moo, boo)
values ('a', 'b', 'c', 10, 20), ('d', 'e', 'f', 30, 40)
-- on conflict do nothing;
on conflict on constraint "foo_pkey" do update
set moo = excluded.moo, boo = excluded.boo;

INSERT 0 2


select *
from foo


bar
baz
bat
moo
boo


a
b
c
10
20

d
e
f
30
40



SELECT 2