Triggers with the same name within the same schema

Copy SQL

WITH triggers AS (SELECT tgname AS trigger_name,
nspname AS trigger_schema, 
c.relname as table_name
FROM pg_trigger t INNER JOIN pg_class c ON t.tgrelid=c.oid
INNER JOIN pg_namespace n ON c.relnamespace=n.oid
WHERE nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
AND tgisinternal='f')
SELECT trigger_name, trigger_schema, Count(*) AS number_of_occurrences, string_agg(table_name, ';<br>' ORDER BY table_name) AS tables
FROM triggers
GROUP BY trigger_name, trigger_schema
HAVING Count(*)>1
ORDER BY Count(*) DESC, trigger_schema, trigger_name;