---

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.prosrc ILIKE '%members_group_recipients%'
ORDER BY n.nspname, p.proname;






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.prosrc ILIKE '%to_portal%'
ORDER BY n.nspname, p.proname;



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.prosrc ILIKE '%chat_idx%'
ORDER BY n.nspname, p.proname;



SELECT pg_get_functiondef(<OID>);