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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
