PostgreSQL Anonymizer is an extension designed to mask or replace personally identifiable information (PII) or sensitive data in a Postgres database. It offers a declarative approach to anonymization, allowing users to define masking rules using PostgreSQL Data Definition Language (DDL) directly within the table definition. This extension aims to provide anonymization by design, emphasizing the importance of developers writing masking rules due to their deep understanding of the data model. Five different masking methods are available, each with its pros and cons. Additionally, various masking functions and detection functions are provided, offering a comprehensive solution to data anonymization within PostgreSQL.
https://postgresql-anonymizer.readthedocs.io/en/stable/