doc-exports/docs/dws/dev/dws_04_0610.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

8.9 KiB

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.