doc-exports/docs/dws/dev/dws_04_0610.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

9.5 KiB

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.