@anon

PostgreSQL Anonymizer security labels

Postgres

Example

Input SQL

-- @anon
CREATE TABLE patients (
  id SERIAL PRIMARY KEY,
  -- @anon.mask('anon.partial(email, 2, $$***$$, 2)')
  email VARCHAR(255) NOT NULL,
  -- @anon.fake('anon.fake_last_name()')
  last_name VARCHAR(100) NOT NULL,
  diagnosis TEXT
);

Compiled Output

SECURITY LABEL FOR anon ON COLUMN "patients"."email"
  IS 'MASKED WITH FUNCTION anon.partial(email, 2, $$***$$, 2)';

SECURITY LABEL FOR anon ON COLUMN "patients"."last_name"
  IS 'MASKED WITH FUNCTION anon.fake_last_name()';

Tags

@anon.mask

Mask this column using a PostgreSQL Anonymizer function

Targets: column

Arguments:Positional: string

@anon.fake

Generate fake data for this column using a PostgreSQL Anonymizer function

Targets: column

Arguments:Positional: string

@anon

Mark this table as containing anonymizable data

Targets: table

Arguments: No arguments.