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.

function_parameters

text

Parameters when the redaction type is partial.

regexp_pattern

text

Format string when the redaction type is regexp.

regexp_replace_string

text

Replacement string when the redaction type is regexp.

regexp_position

integer

Specifies the start replacement position when the redaction type is regexp.

regexp_occurrence

integer

The number of replacements when the redaction type is regexp.

regexp_match_parameter

text

Regular control parameter when the redaction type is regexp.

column_description

text

Description of the redacted column.