Re: Crypt in queries and functions? - Mailing list pgsql-general

From Neil Conway
Subject Re: Crypt in queries and functions?
Date
Msg-id 1043894600.1210.27.camel@tokyo
Whole thread Raw
In response to Crypt in queries and functions?  (Owen Jacobson <ojacobson@mx-deus.net>)
List 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@samurai.com> || PGP Key ID: DB3C29FC




pgsql-general by date:

Previous
From: Alex Zavalin
Date:
Subject: db dump
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Website troubles