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


SELECT
    CAST(fk.confrelid AS regclass) AS reference_table,
    pg_get_constraintdef(fk.oid) AS reference_definition
FROM pg_constraint fk
WHERE fk.conrelid =
      CAST('back_office.ops_assignee_decision' AS regclass)
  AND fk.contype = 'f'
  AND EXISTS (
      SELECT 1
      FROM pg_attribute a
      WHERE a.attrelid = fk.conrelid
        AND a.attnum = ANY (fk.conkey)
        AND a.attname = 'decision_payment_type_code'
  );