Загрузка данных


select
    table_name,
    column_name,
    data_type
from information_schema.columns
where table_schema = 'prod_line'
  and (
      lower(column_name) like '%contribution%'
      or lower(column_name) like '%deduct%'
      or lower(column_name) like '%reserve%'
      or lower(column_name) like '%target%'
      or lower(column_name) like '%own_fund%'
      or lower(column_name) like '%insurance%'
      or lower(column_name) like '%rate%'
  )
order by table_name, ordinal_position;