34.2. Data Masking via Logical Replication #

Another approach is data masking via Logical Replication. To get the masked data this way, you need to set the mask parameter on the publication. For example:

CREATE PUBLICATION mypublication FOR TABLE people WITH (mask=on);

Please check CREATE PUBLICATION for more details.