PG_REDACTION_COLUMN¶
PG_REDACTION_COLUMN records the information about the redacted columns.
Column | 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. |
inherited | bool | Whether a redacted column is inherited from another redacted column. |
policy_oid | OID | OID of the masking policy. Supported by clusters of 8.2.1.100 and later versions. It is used to search for masked column information from the metadata in the system catalog. |