关于postgres数据库字段脱敏
SELECT
SUBSTRING (CAST ("cardId" AS VARCHAR),1,2) || '***************' || SUBSTRING (CAST ("cardId" AS VARCHAR),LENGTH (CAST("cardId" AS VARCHAR)),1),
SUBSTRING (CAST("phone" AS VARCHAR), 1, 3) ...
原创
2019-05-15 17:40:16 ·
2217 阅读 ·
0 评论