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@xxxxxxxxx> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment:
signature.asc
Description: Digital signature
