---

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 ~* 'mail[.]api_new_message_group[[:space:]]*[(]'
ORDER BY n.nspname, p.proname;




SELECT
    n.nspname AS schema_name,
    p.proname AS function_name,
    substring(
        p.prosrc
        from '.{0,150}mail[.]api_new_message_group[[:space:]]*[(].{0,300}'
    ) AS call_fragment
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE p.prosrc ~* 'mail[.]api_new_message_group[[:space:]]*[(]'
ORDER BY n.nspname, p.proname;