Re: SHA1 on postgres 8.3

On Sun, Jan 20, 2008 at 12:21:01AM -0800, Jon Hancock wrote:
> I am trying to port a MySQL db to postgres 8.3rc1.
> In MySQL I have a function SHA1, which is critical for storing and
> authenticating passwords.
> I see some old posts on how to add this function myself.  see:
> http://raveica.comdurav.com/blog/programming/how-do-i-add-sha1-to-postgresql/

It's in contrib in the pgcrypto module. If you use a distribution you
can usually simply just install it.

http://www.postgresql.org/docs/8.3/static/pgcrypto.html

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy