Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ PG_REDACTION_POLICY
Updated on 2025-06-12 GMT+08:00
View PDF

PG_REDACTION_POLICY

PG_REDACTION_POLICY records information about the object to be redacted.

Table 1 PG_REDACTION_POLICY columns

Column

Type

Description

object_oid

OID

OID of the object to be redacted.

policy_name

Name

Name of the redaction 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.

policy_order

float4

Masking policy sequence. This field is supported by 8.2.1.100 and later cluster versions.
Parent Topic: System Catalogs