# pg_rules

The view `pg_rules` provides access to useful information about query rewrite rules.

Table 1. `pg_catalog.pg_rules`

| 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`.