2017.9.5 postgresql加密函數的使用

標籤：加密   iges   9.png   pass   具體步驟   question   enc   from   postgres   

需要安裝的外掛程式的名字：pgcrypto官網地址：https://www.postgresql.org/docs/9.4/static/pgcrypto.htmlstackoverflow:https://stackoverflow.com/questions/8000740/how-do-i-install-pgcrypto-in-postgresql-9-1-on-windows/46046367#46046367https://stackoverflow.com/questions/2647158/how-can-i-hash-passwords-in-postgresql 具體步驟：1.add the extensions:  create extension pgcrypto 2.check the extensions:  select * from pg_available_extensions   3.use the extensions:  select ‘{SHA}‘||encode(digest(‘test‘, ‘sha1‘), ‘base64‘);

 

2017.9.5 postgresql加密函數的使用