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'
);