---

SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'ourpension'
  AND table_name = 'contract'
  AND column_name ILIKE '%scheme%'
ORDER BY ordinal_position




SELECT t1.table_name
FROM information_schema.columns t1
JOIN information_schema.columns t2
    ON t1.table_name = t2.table_name
    AND t1.table_schema = t2.table_schema
WHERE t1.table_schema IN ('back_office', 'ourpension')
  AND t1.column_name = 'contract_id'
  AND t2.column_name = 'scheme_id'
ORDER BY t1.table_name