This table provides information on replacement characters when full masking is specified for masking type.
Column | Data type | Description | Default value |
|---|---|---|---|
number_value | integer | Numeric | 0 |
char_value | varchar(1) | char type | Spaces |
varchar_value | varchar(1) | varchar type | Spaces |
date_value | date | date type | '1970-01-01' |
timestamp_value | timestamp | timestamp type | '1970-01-01 00:00:00' |
Execution example
postgres=# select * from pgx_confidential_values;
number_value | char_value | varchar_value | date_value | ts_value
--------------+------------+---------------+------------+---------------------
0 | | | 1970-01-01 | 1970-01-01 00:00:00
(1 row)