---

SELECT
    p.oid::regprocedure AS routine_name,
    pg_get_functiondef(p.oid) AS routine_definition
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE n.nspname = 'integration'
  AND p.proname = 'get_client_id_api';