PG_REDACTION_COLUMN

PG_REDACTION_COLUMN records the information about the redacted columns.

Table 1 PG_REDACTION_COLUMN columns

Name

Type

Description

object_oid

oid

OID of the object to be redacted.

column_attrno

smallint

attrno of the redacted column.

function_type

integer

Redaction type.

Note

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

function_parameters

text

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

regexp_pattern

text

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

regexp_replace_string

text

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

regexp_position

integer

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

regexp_occurrence

integer

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

regexp_match_parameter

text

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

column_description

text

Description of the redacted column.

function_expr

pg_node_tree

Internal representation of the redaction function.