Updated on 2023-10-31 GMT+08:00

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.

inherited

bool

Whether a redaction policy is inherited from another redaction policy.