PostgreSQL
51.82. pg_rules
The view pg_rules provides access to useful information about query rewrite rules.
Table 51.83. 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.81. |
51.83. |
Copyright © 1996-2023 The PostgreSQL Global Development Group