Re: Question on crypt password

On Fri, 24 May 2002 15:02:08 -0400
"Gregory Seidman" <gss+pg(at)cs(dot)brown(dot)edu> wrote:
> Neil Conway sez:
> } Use contrib/pgcrypto, store the hashed version of the password (say,
> } using SHA1). When you want to check if the correct password is used,
> } hash the string the user entered and compare it to the stored version.
>
> Where is the documentation on this?

In contrib/pgcrypto/README.pgcrypto, which is part of the PostgreSQL
source tree. Perhaps it should be better documented -- it's quite a
neat package.

> Is it like what I wound up doing (see below)?

Similar, but a lot more powerful.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC