---

SELECT
    table_schema,
    table_name,
    column_name,
    data_type
FROM information_schema.columns
WHERE (table_schema = 'prod_line'
       AND table_name IN ('pens_scheme', 'hb_invest_strategy'))
   OR (table_schema = 'ourpension'
       AND table_name = 'pension_scheme')
ORDER BY table_schema, table_name, ordinal_position;