PG_REDACTION_COLUMN¶
PG_REDACTION_COLUMN records the information about the redacted 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. |
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. |