51.83. pg

51.83. `pg_rules`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.83. `pg_rules`

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

Table 51.84. pg_rules Columns

Column Type Description
`schemaname` `name` (references `pg_namespace`.`nspname`) Name of schema containing table
`tablename` `name` (references `pg_class`.`relname`) Name of table the rule is for
`rulename` `name` (references `pg_rewrite`.`rulename`) Name of rule
`definition` `text` Rule definition (a reconstructed creation command)

Column Type

Description

schemaname name (references pg_namespace.nspname)

Name of schema containing table

tablename name (references pg_class.relname)

Name of table the rule is for

rulename name (references 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 and materialized views; those can be seen in pg_views and pg_matviews.