Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_REDACTION_COLUMN

PG_REDACTION_COLUMN

Updated at: Sep 17, 2021 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel