54.21. pg_rules

54.21. `pg_rules`
Prev	Up	Chapter 54. System Views	Home	Next

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

Table 54.21. 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
54.20. `pg_roles`	Home	54.22. `pg_seclabels`