---

SELECT column_name, data_type
FROM information_schema.columns
WHERE table_name ILIKE '%invest_strateg%'
  AND table_name NOT ILIKE '%history%'
ORDER BY table_name, ordinal_position




SELECT table_name
FROM information_schema.tables
WHERE table_schema IN ('back_office', 'ourpension')
  AND table_name ILIKE '%invest%'