Triggers with the same name in different schemas

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, Count(*) AS number_of_occurrences, Count(DISTINCT trigger_schema) AS number_of_different_schemas, string_agg(trigger_schema || '.' || table_name, ';<br>' ORDER BY trigger_schema, table_name) AS tables
FROM triggers
GROUP BY trigger_name
HAVING Count(*)>1 AND Count(DISTINCT trigger_schema)>1
ORDER BY Count(*) DESC, trigger_name;