WITH Tr AS (SELECT
    n.nspname AS trigger_schema,
    t.tgname AS trigger_name,
    em.text AS event_manipulation,        
    c.relname AS trigger_table, 
    np.nspname AS routine_schema,
    p.proname AS routine_name,
        CASE
            WHEN pg_has_role(c.relowner, 'USAGE') THEN ( SELECT rm.m[1] AS m
               FROM regexp_matches(pg_get_triggerdef(t.oid), '.{35,} WHEN \((.+)\) EXECUTE PROCEDURE') rm(m)
             LIMIT 1)
            ELSE NULL
        END AS action_condition,    
        CASE t.tgtype::integer & 1
            WHEN 1 THEN 'ROW'
            ELSE 'STATEMENT'
        END AS action_orientation,
        CASE t.tgtype::integer & 66
            WHEN 2 THEN 'BEFORE'
            WHEN 64 THEN 'INSTEAD OF'
            ELSE 'AFTER'
        END AS action_timing
   FROM pg_namespace n,
    pg_class c,
    pg_trigger t,
    pg_proc p,
    pg_namespace np,
    ( VALUES (4,'INSERT'), (8,'DELETE'), (16,'UPDATE'), (32,'TRUNCATE')) em(num, text)
  WHERE n.oid = c.relnamespace 
  AND c.oid = t.tgrelid 
  AND t.tgfoid=p.oid
  AND p.pronamespace=np.oid
  AND (t.tgtype::integer & em.num) <> 0 
  AND NOT t.tgisinternal 
  AND NOT pg_is_other_temp_schema(n.oid)),
duplicate_triggers AS (SELECT trigger_schema, trigger_table, action_timing, event_manipulation, action_orientation, routine_schema, routine_name, action_condition, Count(*) AS cnt, array_agg(trigger_name) AS triggers
FROM tr
GROUP BY trigger_schema, trigger_table, action_timing, event_manipulation, action_orientation, routine_schema, routine_name, action_condition
HAVING Count(*)>1)
SELECT format('DROP TRIGGER %1$I ON %2$I.%3$I;', unnest(triggers), trigger_schema, trigger_table) AS statements
FROM duplicate_triggers
ORDER BY cnt DESC, trigger_schema, trigger_table;