pg_rules

The view pg_rules provides access to useful information about query rewrite rules.

Table 1. pg_catalog.pg_rules

Name	Type	References	Description
schemaname	name	pg_namespace.nspname	Name of schema containing table
tablename	name	pg_class.relname	Name of table the rule is for
rulename	name	pg_rewrite.rulename	Name of rule
definition	text		Rule definition (a reconstructed creation command)

The pg_rules view excludes the ON SELECT rules of views; those can be seen in pg_views.