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) || '****' || SUBSTRING (CAST ("phone" AS VARCHAR),LENGTH (CAST("phone" AS VARCHAR)) - 3,LENGTH (CAST("phone" AS VARCHAR)))
FROM
desensitization
查询结果:
注意:postgres数据库对字段大小写敏感,含有大写字母的字段需要加上双引号!