PG_REDACTION_COLUMN

PG_REDACTION_COLUMN records the information about the redacted columns.

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