[juliend2]

Also, it has all the encryptions functions one would need to implement authentication mechanisms, in pure SQL.

https://www.postgresql.org/docs/current/pgcrypto.html