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


select
    column_name,
    data_type
from information_schema.columns
where table_schema = 'ourpension'
  and table_name = 'contract_params'
  and (
      lower(column_name) like '%payment%'
      or lower(column_name) like '%payout%'
      or lower(column_name) like '%type%'
  )
order by ordinal_position;