pg_rules
The view pg_rules provides access to useful information about query rewrite rules.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- schemaname, tablename, rulename, definition
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_rules provides access to useful information about query rewrite rules.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| schemaname | name | Nullable | Name of schema containing table |
| tablename | name | Nullable | Name of table the rule is for |
| rulename | name | Nullable | Name of rule |
| definition | text | Nullable | Rule definition (a reconstructed creation command) |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:9a5cb2e01372c5e7d64521850fae4a31ddf7699f93671718ccb4c7184404b3ce
Text language: en · catalog-bilingual-repair:9a5cb2e01372c5e7d64521850fae4a31ddf7699f93671718ccb4c7184404b3ce