Updated on 2024-05-07 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 contains a table.

tablename

name

Name of the table to which the rule applies.

rulename

name

Rule name.

definition

text

Rule definition (reconstructed by the CREATE statement).