PostgreSQL 19 Documentation · 53.24. pg

Documentation → PostgreSQL 19

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4

Pre-release documentation. PostgreSQL 19 Beta 3 is a testing release. The final release may differ.

53.24. `pg_rules`
Prev	Up	Chapter 53. System Views	Home	Next

53.24. `pg_rules` #

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

Table 53.24. 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.

Prev	Up	Next
53.23. `pg_roles`	Home	53.25. `pg_seclabels`

Read the upstream documentation. For corrections, first check the current version.