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