--安装内置加密模块
create extension pgcrypto;
--卸载内置加密模块
drop extension pgcrypto;
--查看加密模块情况
select * from pg_available_extensions where name ~ 'pgcrypto';
--加解密函数测试
select pgp_sym_decrypt(pgp_sym_encrypt('teststr','miyao','cipher-algo=aes128')::bytea,'miyao');