Thread: passwords

passwords

From
"Chris"
Date:
Does postgres have a data type such as mysql to encrypt and store passwords?

Re: passwords

From
Tom Lane
Date:
"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