---

select
    n.nspname as schema_name,
    p.proname as object_name,
    'function' as object_type
from pg_proc p
join pg_namespace n
    on n.oid = p.pronamespace
where p.prosrc ilike '%ГруппаТарифов%'
   or p.prosrc ilike '%actuary.tariff_list%'

union all

select
    schemaname,
    viewname,
    'view'
from pg_views
where definition ilike '%ГруппаТарифов%'
   or definition ilike '%actuary.tariff_list%'

order by object_type, schema_name, object_name;