---

SELECT
    a.attname AS column_name,
    col_description(a.attrelid, a.attnum) AS column_comment,
    pg_get_constraintdef(con.oid) AS foreign_key
FROM pg_attribute a
LEFT JOIN pg_constraint con
    ON con.conrelid = a.attrelid
   AND con.contype = 'f'
   AND a.attnum = ANY(con.conkey)
WHERE a.attrelid =
      'ourpension.application_individual_bank_detail'::regclass
  AND a.attname = 'payment_type';