CREATE EXTENSION IF NOT EXISTS anon CASCADE; SELECT anon.load(); load ------ (1 row) -- -- Generic Types -- -- zip SELECT pg_typeof(anon.random_zip()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- string SELECT pg_typeof(anon.random_string(1)) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) --SELECT anon_string(123456789); -- Date SELECT pg_typeof(anon.random_date_between('1900-01-01'::TIMESTAMP WITH TIME ZONE,now())) = 'TIMESTAMP WITH TIME ZONE'::REGTYPE; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_date_between('0001-01-01'::DATE,'4001-01-01'::DATE)) = 'TIMESTAMP WITH TIME ZONE'::REGTYPE; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_date()) = 'TIMESTAMP WITH TIME ZONE'::REGTYPE; ?column? ---------- t (1 row) -- Integer SELECT pg_typeof(anon.random_int_between(1,3)) = 'INTEGER'::REGTYPE; ?column? ---------- t (1 row) -- -- Personal Data (First Name, etc.) -- -- First Name SELECT pg_typeof(anon.random_first_name()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- Last Name SELECT pg_typeof(anon.random_last_name()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- Email SELECT pg_typeof(anon.random_email()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- Phone SELECT pg_typeof(anon.random_phone('0033')) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) SELECT anon.random_phone(NULL) IS NULL; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_phone()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- Location SELECT pg_typeof(anon.random_city_in_country('France')) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) SELECT anon.random_city_in_country('dfndjndjnjdnvjdnjvndjnvjdnvjdnjnvdnvjdnvj') IS NULL; ?column? ---------- t (1 row) SELECT anon.random_city_in_country(NULL) IS NULL; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_city()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_region_in_country('Italy')) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) SELECT anon.random_region_in_country('c,dksv,kdfsdnfvsjdnfjsdnjfndj') IS NULL; ?column? ---------- t (1 row) SELECT anon.random_region_in_country(NULL) IS NULL; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_region()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_country()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- -- Company -- SELECT pg_typeof(anon.random_company()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- -- IBAN -- SELECT pg_typeof(anon.random_iban()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) -- -- SIRET -- SELECT pg_typeof(anon.random_siret()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) SELECT pg_typeof(anon.random_siren()) = 'TEXT'::REGTYPE; ?column? ---------- t (1 row) ------------------------------------------------------------------------------- -- Masking ------------------------------------------------------------------------------- CREATE TEMPORARY TABLE t1 ( id SERIAL, name TEXT, "CreditCard" TEXT, fk_company INTEGER ); INSERT INTO t1 VALUES (1,'Schwarzenegger','1234567812345678', 1991); COMMENT ON COLUMN t1.name IS ' MASKED WITH ( FUNCTION = random_last_name() )'; COMMENT ON COLUMN t1."CreditCard" IS ' MASKED WITH ( FUNCTION = random_string(12) )'; CREATE TEMPORARY TABLE "T2" ( id_company SERIAL, "IBAN" TEXT, COMPANY TEXT ); INSERT INTO "T2" VALUES (1991,'12345677890','Skynet'); COMMENT ON COLUMN "T2"."IBAN" IS 'MASKED WITH (FUNCTION=random_iban())'; COMMENT ON COLUMN "T2".COMPANY IS 'jvnosdfnvsjdnvfskngvknfvg MASKED WITH (FUNCTION = random_company() ) jenfksnvjdnvkjsnvsndvjs'; SELECT count(*) = 4 FROM anon.mask; ?column? ---------- t (1 row) SELECT func = 'random_iban()' FROM anon.mask WHERE attname = 'IBAN'; ?column? ---------- t (1 row) SELECT anon.anonymize_all_the_things(); NOTICE: ANONYMIZE ALL THE THINGS \o/ NOTICE: Anon t1.name with anon.random_last_name() NOTICE: Anon t1.CreditCard with anon.random_string(12) NOTICE: Anon T2.IBAN with anon.random_iban() NOTICE: Anon T2.company with anon.random_company() anonymize_all_the_things -------------------------- (0 rows) SELECT company != 'skynet' FROM "T2" WHERE id_company=1991; ?column? ---------- t (1 row) SELECT name != 'Schwarzenegger' FROM t1 WHERE id = 1; ?column? ---------- t (1 row) ------------------------------------------------------------------------------- -- End ------------------------------------------------------------------------------- SELECT anon.unload(); unload -------- (1 row) DROP EXTENSION anon;