Guides

Guides to PostgreSQL data masking and subsetting

How to give your team realistic test data without real customer data. For command and option details, see the documentation.

• How to anonymize a PostgreSQL database

  Step-by-step guide to masking PII in PostgreSQL with deterministic transformers that keep joins, foreign keys and unique constraints working.

  Read the guide

• PostgreSQL database subsetting explained

  What database subsetting is, how foreign-key traversal builds a small, consistent copy of PostgreSQL, and how to handle circular keys.

  Read the guide

• Keep PII out of staging databases

  A practical checklist for keeping real customer data out of staging and laptops, with notes for SOC 2, HIPAA, GDPR and India's DPDP Act.

  Read the guide