Updated on 2025-02-27 GMT+08:00

PG_RULES

PG_RULES is used to query useful information about rewriting rules.

Table 1 PG_RULES columns

Name

Type

Description

schemaname

name

Name of the schema that the table is in.

tablename

name

Name of the table to which the rule applies.

rulename

name

Name of a rule.

definition

text

Rule definition (reconstructed by the CREATE statement).