[Postgresql] CRYPT 암호화

CREATE EXTENSION pgcrypto; //pgcrypto 설치

 

ex) SELECT ENCODE(DIGEST('fffff', 'sha512'), 'hex'); //'fffff'를 SHA512 해쉬로 암호화

 

5f25bfc3a6c08f34a81852c21e05b94e14143c5838f507b843909d662b7f446cbe745fddf5e88fee301af35a50ded4fd5e8c3ff8368cca1cccc23485852f2149

=> 결과(length : 128)