PostgreSQL: pg_anonymize, a new extension for simple and transparent data anonymization

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

Taipei, Taiwan - March 9, 2023

pg_anonymize, a new extension for simple and transparent data anonymization

I'm pleased to announce the beta version of pg_anonymize.

pg_anonymize is a PostgreSQL extension that provides simple, robust and transparent infrastructure for data anonymization. Its goal is to ensure that anyone connected with an anonymized role will only ever see the anonymized version of the data without any restriction on the client used (could be psql, pg_dump, your own application or even other tools like pg_sample...) or the number of schemas and relations.

Anonymization is done using a declarative approach, relying on SECURITY LABELs: you only have to declare an expression for each column that should be anonymized that will dynamically perform the anonymization. Any valid expression yielding the correct type can be used, so you can write them in plain sql, plpgsql or any other proc...

Get the full details here: PostgreSQL: pg_anonymize, a new extension for simple and transparent data anonymization

[bot]

Corresponding tweet for this thread:

Devtalk

Share link for this tweet.