SELECT 
  n.nspname AS routine_schema, 
  p.proname AS routine_name, 
  pg_get_function_identity_arguments(p.oid) AS routine_parameters,
  e.extname AS extension_name,
  e.extversion AS extension_version,
CASE WHEN p.prokind='f' THEN 'FUNCTION'
  WHEN p.prokind='p' THEN 'PROCEDURE'
  WHEN p.prokind='a' THEN 'AGGREGATE FUNCTION'
  WHEN p.prokind='w' THEN 'WINDOW FUNCTION' END AS routine_type
FROM 
  pg_catalog.pg_proc p, 
  pg_catalog.pg_namespace n,
  pg_catalog.pg_depend d,
  pg_catalog.pg_extension e
WHERE 
  p.pronamespace = n.oid
  AND p.oid=d.objid
  AND e.oid=d.refobjid
ORDER BY extension_name, routine_schema, routine_name, routine_parameters;