BEGIN; CREATE EXTENSION IF NOT EXISTS anon CASCADE; CREATE TABLE employee ( firstname TEXT, lastname TEXT, phone TEXT, zipcode INTEGER ); INSERT INTO employee VALUES ('Sarah','Connor','0609110911'); SELECT * FROM employee; SECURITY LABEL FOR anon ON COLUMN employee.firstname IS 'MASKED WITH VALUE ''XXXX'' '; SECURITY LABEL FOR anon ON COLUMN employee.lastname IS 'MASKED WITH VALUE $$REDACTED$$ '; SECURITY LABEL FOR anon ON COLUMN employee.phone IS 'MASKED WITH VALUE NULL '; COMMENT ON COLUMN employee.zipcode IS 'MASKED WITH VALUE 100'; SELECT anon.anonymize_table('employee'); SELECT count(*)=1 FROM anon.pg_masking_rules WHERE masking_filter = '$$REDACTED$$'; SELECT count(*)=1 FROM anon.pg_masking_rules WHERE masking_filter = 'NULL'; SELECT count(*)=1 FROM anon.pg_masking_rules WHERE masking_filter = '100'; ROLLBACK;