PostgreSQL数据库字段脱敏

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数据库对字段大小写敏感，含有大写字母的字段需要加上双引号！

文章来源：https://blog.csdn.net/TC_HaoShuai/article/details/90241404