Date: Fri, 27 Dec 2002 10:01:30 -0500
From: "Campano, Troy" <Troy.Campano@LibertyMutual.com>
>
> Is there a PostgreSQL function that allows you to store passwords, but it encrypts them?
> If not, are there any recommendations for storing passwords?
>
The easiest solution would be a stored procedure written in C that simply
calls the crypt() function (for details: "man crypt"). In that case you will
also need to store the "salt" with the encrypted password.
Even if you have not yet written any stored procedure, it should be done
in less than two hours. See the documentation on "server side programming" for details.
Hope this helps,
Christoph Dalitz