PostgreSQL脱敏示例

发布时间：2020-12-13 16:10:26 所属栏目：百科来源：网络整理

导读：mydb=# create table test_desensitization(id integer,name varchar(32),phone_num varchar(11));CREATE TABLEmydb=# insert into test_desensitization select num,‘name_‘||num,18500000000+(random()*90000000)::int from generate_series(1,100) g(nu

mydb=# create table test_desensitization(id integer,name varchar(32),phone_num varchar(11));
CREATE TABLE
mydb=# insert into test_desensitization select num,‘name_‘||num,18500000000+(random()*90000000)::int from generate_series(1,100) g(num);;
INSERT 0 100
mydb=# create table test_desensitization_result as select id,substring(name,1,2)||‘******‘||substring(name,length(name),1) as name,substring(phone_num,3)||‘****‘||substring(phone_num,length(phone_num) -3,4) as phone_num from test_desensitization ;
SELECT 100
mydb=# select * from test_desensitization_result ;
 id  |   name    |  phone_num
-----+-----------+-------------
   1 | na******1 | 185****9782
   2 | na******2 | 185****2419
   3 | na******3 | 185****5163
   4 | na******4 | 185****9263
   5 | na******5 | 185****1941
   6 | na******6 | 185****0390
   7 | na******7 | 185****2158
   8 | na******8 | 185****8646
   9 | na******9 | 185****9253
  10 | na******0 | 185****4371

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!