Re: Question on crypt password - Mailing list pgsql-general

From Neil Conway
Subject Re: Question on crypt password
Date
Msg-id 20020524154832.0919ab62.nconway@klamath.dyndns.org
Whole thread Raw
In response to Re: Question on crypt password  (Gregory Seidman <gss+pg@cs.brown.edu>)
List pgsql-general
On Fri, 24 May 2002 15:02:08 -0400
"Gregory Seidman" <gss+pg@cs.brown.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@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case Insensitive Data Type
Next
From: Darren Ferguson
Date:
Subject: Re: problem with my function