Re: passwords - Mailing list pgsql-novice

From Tom Lane
Subject Re: passwords
Date
Msg-id 23349.1074719573@sss.pgh.pa.us
Whole thread Raw
In response to passwords  ("Chris" <codle@valuelinx.net>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: "Chris"
Date:
Subject: passwords
Next
From: Paul Makepeace
Date:
Subject: Using OLD on INSERT