Skip to content

`SECURITY LABEL FOR anon ON TABLE user IS 'MASKED WHEN id > 5000'

Hi, I have a case where I need to anonymize an an entire table except for a few rows which are known to be test rows and don't need to go through anonymization because that would break stuff.

I know I can temporarily save those records on a side table, anonymize it all and restore them or update based on PK, but this isn't always easy/nice, especially not if I need to repeat this on many tables.

It would be nice for this great extension to support conditional anonymization, i.e definining an optional where clause which would be added to the anonymization update before it starts running.

Thanks.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information