PostgreSQL Anonymizer - an addition to the PostgreSQL DBMS that allows you to hide or change confidential data or information that is a trade secret. Data hiding occurs on the fly, using lists of users for anonymization and configured rule templates.
The tool can be used to provide access to the database to third parties (for example, analytical services), automatically cutting out personal data from requests, such as phone numbers or credit cards, or using more complex methods - replacing user names, company names, and so on with fictitious information .
Using the pg_dump_anon utility provided by the tool
it is possible to make an anonymized database dump for transfer to third parties.
>>> Source (PostgreSQL license)
>>> Project page with installation instructions
Source: linux.org.ru