---
title: "pg_rules"
id: view-pg-rules
pg_version: "20devel"
---

<a id="view-pg-rules"></a>

## 53.24. pg_rules

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

**pg_rules Columns**

| Column Type | Description | 
| --- | --- |
| `schemaname` `name` (references [pg_namespace](catalog-pg-namespace.md).`nspname`) | Name of schema containing table |
| `tablename` `name` (references [pg_class](catalog-pg-class.md).`relname`) | Name of table the rule is for |
| `rulename` `name` (references [pg_rewrite](catalog-pg-rewrite.md).`rulename`) | Name of rule |
| `definition` `text` | 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](view-pg-views.md) and [pg_matviews](view-pg-matviews.md).