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


select
    n.nspname as schema_name,
    p.proname as function_name,
    btrim(line) as source_line
from pg_proc p
join pg_namespace n
    on n.oid = p.pronamespace
cross join lateral regexp_split_to_table(p.prosrc, E'\n') as line
where line ilike '%МГДНакПериодС%'
   or line ilike '%МГДНакПериодПо%'
   or line ilike '%МГДВыплПериодС%'
   or line ilike '%МГДВыплПериодПо%'
order by n.nspname, p.proname;