PG_REDACTION_COLUMN

PG_REDACTION_COLUMN records the information about the masked columns.

Table 1 PG_REDACTION_COLUMN columns

Name

Type

Description

object_oid

oid

OID of the object to be masked

column_attrno

smallint

attrno of the masked column

function_type

integer

Masking type

Note

This column is reserved. It is used only for forward compatibility of masked column information in earlier versions. The value can be 0 (NONE) or 1 (FULL).

function_parameters

text

Parameters used when the masking type is partial (reserved).

regexp_pattern

text

Pattern string when the masking type is regexp (reserved).

regexp_replace_string

text

Replacement string when the masking type is regexp (reserved).

regexp_position

integer

Start and end replacement positions when the masking type is regexp (reserved).

regexp_occurrence

integer

Replacement times when the masking type is regexp (reserved).

regexp_match_parameter

text

Regular control parameter used when the masking type is regexp (reserved).

column_description

text

Description of the masked column

function_expr

pg_node_tree

Internal representation of the masking function.

inherited

bool

Whether a masked column is inherited from another masked column.