---

SELECT
    n.nspname AS schema_name,
    p.proname AS function_name,
    pg_get_function_identity_arguments(p.oid) AS arguments
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE p.prokind IN ('f', 'p')
  AND n.nspname NOT IN ('pg_catalog', 'information_schema')
  AND (
      p.proname ILIKE '%rops%'
      OR p.prosrc ILIKE '%rops%'
      OR p.prosrc ILIKE '%ропс%'
      OR p.prosrc ILIKE '%возврат%спн%'
  )
ORDER BY
    n.nspname,
    p.proname;