"Chris" <codle@valuelinx.net> writes:
> Does postgres have a data type such as mysql to encrypt and store passwords?
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