PG_REDACTION_POLICY

PG_REDACTION_POLICY records information about the object to be redacted.

Table 1 PG_REDACTION_POLICY columns

Name

Type

Description

object_oid

oid

OID of the object to be redacted.

policy_name

name

Name of the redact policy.

enable

boolean

Policy status (enabled or disabled).

Note

The value can be:

  • true: enabled.

  • false: disabled.

expression

pg_node_tree

Policy effective expression (for users).

policy_description

text

Description of a policy.