pg_rules

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

Columns 4

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

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`schemaname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tablename`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`rulename`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`definition`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Definition snapshot: english-manuals:5da9fa91410d3f17a34ac4b9b2f… · English manual source