---

SELECT
    p.oid::regprocedure AS routine_signature,
    pg_get_functiondef(p.oid) AS function_definition
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE n.nspname = 'ourpension'
  AND p.proname = 'f_get_available_applications'
ORDER BY p.oid::regprocedure::text;