PG_RULES

PG_RULES displays information about rewrite rules.

Table 1 PG_RULES columns

Name

Type

Description

schemaname

name

Name of the schema that contains the table

tablename

name

Name of the table the rule is for

rulename

name

Rule name

definition

text

Rule definition (a reconstructed creation command)