How can I query what security labels exist on a table?

Question

Using the postgresql-anonymizer Postgres extension I've set security labels for masking on a number of columns.

e.g.

SECURITY LABEL FOR anon ON COLUMN "Customer"."firstName" IS 'MASKED WITH FUNCTION anon.fake_first_name()

I want a way to query if it's been added, and see what the label is. How do I do this?

score 0 · Accepted Answer · answered May 13 '23 at 08:23

Query pg_seclabels to find the table and columns the labels are assigned to.

objname will contain the table and column e.g. "Users"."firstName", label, as the name gives away, will contain the label. e.g. 'MASKED WITH FUNCTION anon.fake_first_name()

  SELECT objname, label
  FROM pg_seclabels
  WHERE provider = 'anon';

How can I query what security labels exist on a table?

1 Answers1