Masking target refers to a column to which a masking policy will be applied. When referring to a masking target or a function that includes a masking target, the execution result will be changed and obtained.
The following commands can change the execution result:
SELECT
COPY
pg_dump
pg_dumpall
Note
If a masking target is specified to INSERT...SELECT target columns, processing will be performed using data before change.
If a masking target other than SELECT target columns is specified, processing will be performed using data before change.
If a masking target is specified in a function where the data type will be converted, an error will occur.
