| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Jon Hancock <redstarling(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SHA1 on postgres 8.3 |
| Date: | 2008-01-20 16:38:46 |
| Message-ID: | 20080120163846.GI9599@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2008-01-20 16:46:19 | Re: Sun acquires MySQL |
| Previous Message | Martijn van Oosterhout | 2008-01-20 16:34:09 | Re: postgres.org src build vs. enterprisedb installer |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2008-01-20 17:24:11 | Re: [GENERAL] SHA1 on postgres 8.3 |
| Previous Message | Gregory Stark | 2008-01-20 15:11:28 | Re: Transaction Snapshot Cloning |