PG_REDACTION_COLUMN

Updated on 2024-12-19 GMT+08:00

View PDF

PG_REDACTION_COLUMN records the information about the masked columns.

**Table 1** PG_REDACTION_COLUMN 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.