The view pg_rules provides access to useful information about query rewrite rules.
Table 42-40. pg_rules Columns
| 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.
