BEGIN;
CREATE TABLE "Phone" (
  phone_owner  TEXT,
  phone_number TEXT
);
INSERT INTO "Phone" VALUES
('Omar Little','410-719-9009'),
('Russell Bell','410-617-7308'),
('Avon Barksdale','410-385-2983');
SET anon.transparent_dynamic_masking TO true;
CREATE ROLE jimmy LOGIN;
GRANT USAGE ON SCHEMA public TO jimmy;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO jimmy;
SECURITY LABEL FOR anon ON ROLE jimmy IS 'MASKED';
SECURITY LABEL FOR anon ON COLUMN "Phone".phone_owner
IS 'MASKED WITH VALUE $$CONFIDENTIAL$$ ';
SECURITY LABEL FOR anon ON SCHEMA pg_catalog IS 'TRUSTED';
SECURITY LABEL FOR anon ON COLUMN "Phone".phone_number
IS 'MASKED WITH FUNCTION pg_catalog.substring(pg_catalog.md5(phone_number),0,12)';
SET anon.transparent_dynamic_masking TO true;
COPY public."Phone" TO stdout;
Omar Little	410-719-9009
Russell Bell	410-617-7308
Avon Barksdale	410-385-2983
SET ROLE jimmy;
COPY public."Phone" TO stdout;
CONFIDENTIAL	a0769efeda7
CONFIDENTIAL	50f25331bb9
CONFIDENTIAL	f52c939aaf7
-- TODO
-- COPY (SELECT * FROM "Phone") TO stdout;
ROLLBACK;