with s(name, distance) as ( values ('archer goblin', 10), ('dragon', 50)), the_ids as ( insert into monster(name) select name from s returning id, name)insert into ranged_monster (id_monster, distance)select id, distancefrom s inner join the_ids using (name)
