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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot