Does postgres have a data type such as mysql to encrypt and store passwords?

"Chris" <codle (AT) valuelinx (DOT) net> writes:
There's no datatype specialized to that purpose, but you could store
the MD5 hash of a password using the md5() function (standard since
7.4), or use one of the functions in the contrib/pgcrypto/ package.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org