---

select
    table_schema,
    table_name,
    column_name,
    data_type,
    numeric_precision,
    numeric_scale
from information_schema.columns
where table_schema = 'ourpension'
  and (
        (table_name = 'load_snv'
         and column_name = 'sum_tax_deduction')
     or (table_name = 'year_tax_deduction'
         and column_name in ('sum_income', 'sum_tax_deduction'))
  )
order by table_name, column_name;