pg_rules
The pg_rules view provides access to useful information about query rewrite rules.
The pg_rules view excludes the ON SELECT rules of views and materialized views; those can be seen in pg_views and pg_matviews.
| Column | 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) |