PostgreSQL
51.83. pg_rules
The view pg_rules provides access to useful information about query rewrite rules.
Table 51.84. pg_rules Columns
| Name | Type | References | Description |
|---|---|---|---|
|
|
|
Name of schema containing table |
|
|
|
Name of table the rule is for |
|
|
|
Name of rule |
|
|
Rule definition (a reconstructed creation command) |
+
The pg_rules view excludes the ON SELECT rules of views and materialized views; those can be seen in pg_views and pg_matviews.
| Prev | Up | Next |
|---|---|---|
51.82. |
51.84. |
Submit correction
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Copyright © 1996-2023 The PostgreSQL Global Development Group