本地windows版本PG数据库需要执行 CREATE EXTENSION pgcrypto;
linux版本需要DBA运维安装插件pgcrypto
pg加密解密
-- 加密
select encode(encrypt('13823280917','4q&Q8eHgJ_fZ','aes'),'hex');
-- 解密
select encode(decrypt(decode('d8ccb3dc8ccbed6a50abec13f59c0a4a','hex'),'4q&Q8eHgJ_fZ','aes'),'escape');
替换掉mysql的加密函数select AES_DECRYPT(UNHEX('d8ccb3dc8ccbed6a50abec13f59c0a4a'),'4q&Q8eHgJ_fZ');
