System Catalogs / System views
pg_rules
Read the PG 18 manualThe view pg_rules provides access to useful information about query rewrite rules.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System views
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
schemaname | name | Name of schema containing table pg_namespace.nspname |
tablename | name | Name of table the rule is for pg_class.relname |
rulename | name | Name of rule pg_rewrite.rulename |
definition | text | Rule definition (a reconstructed creation command) |
Column history across versions
Version history 1
- 8.1 → 8.2 reworded
Definition snapshot: english-manuals:3997ae0c43311c97bbb08c9907b… · English manual source