F.1 pgx_confidential

This table provides information on masking target for which masking policies are set.

Column	Type	Description
schema_name	varchar(63)	Schema name of table for which a masking policy is applied
table_name	varchar(63)	Name of table for which a masking policy is applied
policy_name	varchar(63)	Masking policy name
column_name	varchar(63)	Masking target name
function_type	varchar(63)	Masking type 'FULL': Full masking 'PARTIAL': Partial masking 'REGEXP': Regular expression masking
function_parameters	varchar(1024)	Masking format for partial masking
regexp_pattern	varchar(1024)	Search pattern for regular expression masking
regexp_replacement	varchar(1024)	Replacement character/string for regular expression masking
regexp_flags	varchar(20)	Regular expression flags
column_description	varchar(1024)	Masking target description

Execution example

postgres=# select * from pgx_confidential_columns;
 schema_name | table_name | policy_name | column_name | function_type |          function_parameters           | regexp_pattern | regexp_replacement | regexp_flags | column_description 
-------------+------------+-------------+-------------+---------------+----------------------------------------+----------------+--------------------+-------------+--------------------
 public      | t1         | p1          | c1          | FULL          |                                        |                |                    |             | 
 public      | t1         | p1          | c2          | PARTIAL       | VVVFVVVVFVVVV, VVV-VVVV-VVVV, *, 4, 11 |                |                    |             | 
(2  row)

F.1 pgx_confidential_columns