Data Masking in PG
summary
Compares three Postgres extensions and finds Postgres SQL Anonymizer actually meets requirements, installs as an extension and runs SQL to produce realistic but nonreversible data for reproducing bugs. Shows masking functions: randomization, faking, partial scrambling, shuffling and noise, plus custom functions. Distinguishes static masking that alters stored rows from dynamic masking that returns masked SELECT results. Mentions other uses: software testing, user training and sales demos while preserving production confidentiality.
AI-written summary · about
related talks
32mAnonymization and Dynamic Masking with PostgreSQL
32mAnonymizing Data in Postgres Without Losing Your Mind (or Your
34mDatabase Anonymization with PostgreSQL
29mFinally Respecting GDPR Article 25 with PostgreSQL Anonymizer
51mInexpensive Datamasking for MySQL with ProxySQL
24mData Masking & Virtualization
35mBreakout Session
26mDefining a Data Masking Framework at Scale