Postgres 12

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

CREATE TABLE logo (
    id int,
    country_id int
);

INSERT INTO logo VALUES (10, 100), (20, 200), (30, 300);

CREATE TABLE logo_settings (
    id serial,
    targeted boolean
);

CREATE TABLE logo_settings_targeted (
    logo_settings_id int,
    country_id int
);
3 rows affected

WITH countries AS  (
    SELECT id, country_id, row_number() OVER () FROM logo
), ins_settings AS (
    INSERT INTO logo_settings(targeted)
    SELECT true FROM countries c
    RETURNING id
)
INSERT INTO logo_settings_targeted (logo_settings_id, country_id)
SELECT
  ins.id, c.country_id
FROM
  (SELECT id, row_number() OVER () FROM ins_settings) ins
JOIN countries c ON c.row_number = ins.row_number
3 rows affected

SELECT * FROM logo_settings;


id
targeted


1
t

2
t

3
t


SELECT * FROM logo_settings_targeted


logo_settings_id
country_id


1
100

2
200

3
300