An example of the operation on the server is shown below.
Confirm information about a masking target where a masking policy is set
Refer to the pgx_confidential_columns table to confirm the masking target where the masking policy is set.
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)
Confirm information about the masking policy content
Refer to pgx_confidential_policies to confirm the masking policy content.
postgres=# select * from pgx_confidential_policies; schema_name | table_name | policy_name | expression | enable | policy_description -------------+------------+-------------+------------+--------+-------------------- public | t1 | p1 | 1=1 | t | (1 row)
See
Refer to "F.1 pgx_confidential_columns" for information on the pgx_confidential_columns table.
Refer to "F.2 pgx_confidential_policies" for information on the pgx_confidential_policies table.