WITH routines AS (SELECT pg_namespace.nspname AS routine_schema, 
pg_proc.proname AS routine_name,    
pg_get_function_arguments(pg_proc.oid) AS parameters,
CASE WHEN pg_proc.prokind='f' THEN 'FUNCTION'
WHEN pg_proc.prokind='p' THEN 'PROCEDURE'
WHEN pg_proc.prokind='a' THEN 'AGGREGATE FUNCTION'
WHEN pg_proc.prokind='w' THEN 'WINDOW FUNCTION' END AS routine_type
FROM pg_catalog.pg_proc, pg_catalog.pg_namespace
WHERE pg_proc.pronamespace = pg_namespace.oid 
AND pg_proc.proname NOT IN ('f_assume_you_must_use_files', 'f_check_format_comma_separated_list', 'f_check_password', 'f_default_value_with_no_match') 
AND pg_namespace.nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL))
SELECT routine_name, routine_type, parameters, string_agg(routine_schema, ';<br>' ORDER BY routine_schema) AS schemas, Count(*) AS number_of_routines
FROM routines
GROUP BY routine_type, routine_name,  parameters
HAVING Count(*)>1
ORDER BY Count(*) DESC, routine_type, routine_name,  parameters;