| PostgreSQL 8.1.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 42. System Catalogs | Fast Forward | Next |
The view pg_rules provides access to useful information about query rewrite rules.
Table 42-40. pg_rules Columns
| Name | 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) |
The pg_rules view excludes the ON SELECT rules of views; those can be seen in pg_views.