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;