Postgres 13

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

CREATE TABLE other_table (id int PRIMARY KEY);
INSERT INTO other_table VALUES (1);

CREATE TABLE target (
    a json,
    b integer,
    c text[],
    id integer,
    CONSTRAINT id_fkey FOREIGN KEY (id)
        REFERENCES other_table(id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
);

CREATE TABLE



INSERT 0 1



CREATE TABLE


WITH ins (a, b, c, id) AS (
	VALUES ('{"answer":42}'::json,42,array['foo','bar'],1)
) 
INSERT INTO target (a,b,c,id)
SELECT ins.a,ins.b,ins.c,other_table.id 
FROM ins 
LEFT JOIN other_table ON ins.id = other_table.id;


INSERT 0 1


SELECT * FROM target;


a
b
c
id


{"answer":42}
42
{foo,bar}
1



SELECT 1