Hi
My name's Damien Clochard and I'm the main developer of the PostgreSQL
Anonymizer extension. This extension relies heavily on security labels.
Among other things, users can add labels to define a "masking rule" upon
a column and to declare that a roles is "maske
Le 25.02.2025 10:34, Andres Freund a écrit :
Hi,
On February 25, 2025 10:08:44 AM GMT+01:00, Damien Clochard
wrote:
So my first question is : Do you think it would be helpful to update
the SECURITY LABEL command documentation to clarify that security
labels are not concerned by object
Hello,
As I am involved in the PostgreSQL Anonymizer extension, I found that
the random(min,max) functions introduced recently are very useful to
generate synthetic data or define a masking policy.
I decided to submit a similar set of functions for random dates and
times.
So this adds 5 ne
Le 10.07.2025 00:14, Tom Lane a écrit :
Damien Clochard writes:
So this adds 5 new variants of the random() function:
random(min date, max date) returns date
random(min time, max time) returns time
random(min time, max time, zone text) returns timetz
random(min timestamp
Le 21.07.2025 21:06, Greg Sabino Mullane a écrit :
Damien, maybe we can let the time ones go? Tom and I are not big fans
of those, and nobody else has stepped up to defend them.
Sure !
Here's a second version with the following changes
- remove time and timetz variants
- disallow infinity bo
