By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE
CREATE TABLE
INSERT 0 2
DROP TABLE
CREATE TABLE
INSERT 0 4
| table_b_fks | array_agg |
|---|---|
| {2,3} | {"name 2","name 3"} |
| {1,2,4} | {"name 1","name 2","name 4"} |
SELECT 2