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


select
    cp.contract_id,
    c.number,
    cp.min_actuarial_yield,
    c.product_id
from ourpension.contract_params cp
join ourpension.contract c
    on c.id = cp.contract_id
where cp.min_actuarial_yield is not null
order by cp.contract_id desc
limit 20;




select
    id,
    name,
    brief
from prod_line.param_pl
where lower(name) like '%актуар%'
   or lower(brief) like '%актуар%'
   or lower(name) like '%доходност%'
order by id;