Загрузка данных


SELECT
    n.nspname AS schema_name,
    c.relname AS table_name,
    a.attname AS column_name
FROM pg_constraint con
JOIN pg_class c
    ON c.oid = con.conrelid
JOIN pg_namespace n
    ON n.oid = c.relnamespace
JOIN pg_class rc
    ON rc.oid = con.confrelid
JOIN pg_namespace rn
    ON rn.oid = rc.relnamespace
JOIN unnest(con.conkey) WITH ORDINALITY k(attnum, ord)
    ON true
JOIN pg_attribute a
    ON a.attrelid = c.oid
   AND a.attnum = k.attnum
WHERE con.contype = 'f'
  AND rn.nspname = 'prod_line'
  AND rc.relname = 'hb_param_pl_multiselect'
ORDER BY n.nspname, c.relname, a.attname;