Re: Crypt in queries and functions?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Owen Jacobson <ojacobson(at)mx-deus(dot)net>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Crypt in queries and functions?
Date: 2003-01-30 02:43:20
Message-ID: 1043894600.1210.27.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 2003-01-29 at 21:24, Owen Jacobson wrote:
> Passwords should, for obvious reasons, be stored encrypted. I'm
> inclined to do this in a unixish way, using crypt(). However, there
> doesn't seem to be a crypt function in PostgreSQL's function list.

http://www.ca.postgresql.org/docs/faq-english.html#4.28

Short answer: use contrib/pgcrypto

Cheers,

Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-01-30 02:52:07 Re: Website troubles
Previous Message Alex Zavalin 2003-01-30 02:35:44 db dump