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.