Description
Changes replacement characters when full masking is specified for masking type
Format
pgx_update_confidential_values( [number_value := 'numberValue'] [, char_value := 'charValue'] [, varchar_value := 'varcharValue'] [, date_value := 'dateValue'] [, ts_value := 'tsValue'] )
Argument
Details are as follows.
Argument | Data type | Description |
|---|---|---|
number_value | integer | Replacement character in numeric type |
char_value | varchar(1) | Replacement character in char type |
varchar_value | varchar(1) | Replacement character in varchar type |
date_value | date | Replacement character in date type |
ts_value | timestamp | Replacement character in timestamp type |
Return value
Return value | Description |
|---|---|
TRUE | Ended normally |
FALSE | Ended abnormally |
Execution example
Using '*' as a replacement character in char type and varchar type
postgres=# select pgx_update_confidential_values(char_value := '*', varchar_value := '*'); pgx_update_confidential_values --------------------------------- t (1 row)
Description
The arguments for the pgx_update_confidential_values system management function can be specified in any order.
Specify one or more arguments for the pgx_update_confidential_values system management function. A replacement character is not changed for an omitted argument.
See
Refer to "String Constants" in the PostgreSQL Documentation for information on the strings to specify for arguments.
