An example of the operation on the server is shown below.
Delete a masking policy
Execute the pgx_drop_confidential_policy system management function to delete a masking policy.
postgres=# select pgx_drop_confidential_policy(table_name := 't1', policy_name := 'p1'); pgx_drop_confidential_policy ------------------------------- t (1 row)
Confirm the displayed data
Confirm that the original data is displayed by deleting the masking policy.
postgres=# select * from t1; c1 | c2 ----+--------------- 1 | 012-3456-7890 2 | 012-3456-7891 3 | 012-3456-7892 (3 row)
See
Refer to "B.4.3 pgx_drop_confidential_policy" for information on the gx_drop_confidential_policy function.