Description
Deletes masking policies
Format
pgx_drop_confidential_policy( [schema_name := 'schemaName', ] table_name := 'tableName', policy_name := 'policyName' )
Argument
Details are as follows.
Argument | Data type | Description | Default value |
|---|---|---|---|
schema_name | varchar(63) | Schema name of table for which a masking policy is deleted | 'public' |
table_name | varchar(63) | Name of table for which a masking policy is deleted | Mandatory |
policy_name | varchar(63) | Masking policy name | Mandatory |
Details about whether arguments can be omitted are as follows.
Argument | Mandatory or optional |
|---|---|
schema_name | Y |
table_name | N |
policy_name | N |
Y: Can be omitted; N: Cannot be omitted
Return value
Return value | Description |
|---|---|
TRUE | Ended normally |
FALSE | Ended abnormally |
Execution example
Deleting masking policy p1
postgres=# select pgx_drop_confidential_policy(table_name := 't1', policy_name := 'p1'); pgx_drop_confidential_policy ------------------------------- t (1 row)
Description
The arguments for the pgx_drop_confidential_policy system management function can be specified in any order.
Note
If a table for which a masking policy is to be applied is deleted, delete the masking policy as well.
See
Refer to "String Constants" in the PostgreSQL Documentation for information on the strings to specify for arguments.
