WITH rules AS (SELECT 
  r.schemaname AS rule_schema, 
  r.tablename AS host_table, 
  r.rulename AS rule_name, 
  substring(r.definition, 'ON[[:space:]](SELECT|INSERT|UPDATE|DELETE)') AS event,
  substring(r.definition, 'DO.*$') AS rule_definition
FROM 
  pg_catalog.pg_rules r, 
  pg_catalog.pg_namespace n, 
  pg_catalog.pg_authid u
WHERE 
  r.schemaname = n.nspname AND
  n.nspowner = u.oid AND 
 (n.nspname = 'public' OR u.rolname <> 'postgres'))
SELECT rule_definition, string_agg(rule_schema || '.' || host_table || ' ' || event, ',<br>' ORDER BY rule_schema, host_table, event) AS rule_context
FROM rules
GROUP BY rule_definition;