Top
Enterprise Postgres 16 Operation Guide

8.2.5 Deleting a Masking Policy

An example of the operation on the server is shown below.

  1. 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)
  2. 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