postgresqlanonymize

anonymize_table appears to convert table names input to lowercase


I'm testing out using anonymize_table(table_name) via postgresql-anonymizer on a database to attempt to anonymise data.

However, when using the command SELECT anon.anonymize_table('Users'). It returns the error message: ERROR: column "Users" does not exist

When listing the tables with /dt, I see the table in the output as expected.

public | Users | table | postgres


Solution

  • Maybe try this:

    SELECT anon.anonymize_table('"Users"');