Obfuscating names with the same length in PostgreSQL

Question

I have a users table in the database with a first_name column and a last_name column, I want to obfuscate the names but keep them at the same original length and upper/lower case, so for example, 'Aiden' would be 'Xxxxx' and 'Pierce' would be 'Xxxxxx'

What's the best way to do that?

Vamsi Prabhala · Accepted Answer · 2017-05-16 23:54:43Z

3

You can use the function REPEAT.

select 
case when initcap(first_name)=first_name then initcap(repeat('x',length(first_name))) else repeat('x',length(first_name)) end,
case when initcap(last_name)=last_name then initcap(repeat('x',length(last_name))) else repeat('x',length(last_name)) end
from tablename

edited May 16, 2017 at 23:54

answered May 16, 2017 at 23:48

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Obfuscating names with the same length in PostgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related