Re: Proposal for Integrating Data Masking and anonymization into PostgreSQL

Hi Osman

See postgresql_anonymizer
https://gitlab.com/dalibo/postgresql_anonymizer/ and pg_anonymize
https://github.com/rjuju/pg_anonymize , where the former has more
functionality, like synthetic data generation (if you need that).

Yours, Stefan

Am Di., 29. Okt. 2024 um 10:01 Uhr schrieb Hosney Osman
<hosneybinosman@gmail.com>:
>
> could you please provide me with reference or article or example for this scenario
> for example i have schema include 4 table
> and i want to anonymize it in another schema
> how to do that
>
> On Wed, Oct 23, 2024 at 4:25 PM Alastair Turner <minion@decodable.me> wrote:
>>
>> Hi Hosney
>>
>> On Wed, 23 Oct 2024, 15:17 Hosney Osman, <hosneybinosman@gmail.com> wrote:
>>>
>>> Dear PostgreSQL Development Team,
>>>
>>> I am writing to propose the development of native data masking and anonymization features within PostgreSQL. As a
long-timeuser of PostgreSQL, 
>>>
>>> I have observed a growing need for efficient and secure data handling, particularly in compliance with regulations
likeGDPR 
>>
>> This requirement already seems to be well served by extensions. pg_anonymize, for instance, uses the meta data tools
availablein the database, like security labels, to manage the values returned to users. 
>>
>> Is there any functionality, or usability, in this area which you believe can't be delivered by an extension?
>>
>> Regards
>>
>> Alastair