Database & SQL expert

[metasnw]

Data Masking for testing and tuning on realistic data

SQL performance tuning requires access to a database with a realistic volume, data distribution and relationships, but with all private data masked, while preserving mandatory formats.There is a need for both on-the-fly masking while accessing the database on-line through a testing PostgreSQL user with limited privileges and to export the schema having all private data masked. It would be nice to have a simple solution that can be easily adopted by the wider PostgreSQL community and eventually …