---

SELECT
    n.nspname AS schema_name,
    p.proname AS function_name,
    p.oid::regprocedure AS signature
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE p.prokind IN ('f', 'p')
  AND (
        pg_get_functiondef(p.oid) ILIKE '%members_group_recipients%'
        OR pg_get_functiondef(p.oid) ILIKE '%to_portal%'
        OR pg_get_functiondef(p.oid) ILIKE '%chat_idx%'
      )
ORDER BY n.nspname, p.proname;




SELECT
    schemaname,
    viewname
FROM pg_views
WHERE definition ILIKE '%members_group_recipients%'
   OR definition ILIKE '%to_portal%'
   OR definition ILIKE '%chat_idx%'
ORDER BY schemaname, viewname;