On Wed, Oct 18, 2000 at 03:11:12PM -0700, Nate Lawson wrote:
> In MySQL, I can get a hash of a VARCHAR by using the PASSWORD('') call. I
> know for DB admin there is pg_passwd, but is there a function interface so
> that I can get password hashes of arbitrary strings in SQL? (Note that I
> mean crypto hashes like MD5 and hopefully compatible with the hashes used
> for pg_passwd).
There was a user-contributed set of functions posted to the mailing list
in the past couple weeks that does exactly what you're looking for. The
code does MD5 and SHA1 hashes (I'm not sure what MySQL does). I haven't
gotten around to testing it myself, but it looked interesting.
Check the archives, it should be there.
HTH,
Neil
--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
I am not interested in the past. I am interested in the future for
that is where I intend to spend the rest of my life.
-- Charles F. Ketterring