Re: md5 - Mailing list pgsql-novice

From Thom Brown
Subject Re: md5
Date
Msg-id AANLkTincsU444ElnUGSzOVyN9_vwV8ZeCPTBNHg5m122@mail.gmail.com
Whole thread Raw
In response to md5  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
List pgsql-novice
On 24 June 2010 19:25, Jean-Yves F. Barbier <12ukwn@gmail.com> wrote:
> Hi list,
>
> As md5 isn't very safe, is it planned to introduce sha-256/sha-512)?
>

You can use crypt() in pgcrypto if you want that:
http://www.postgresql.org/docs/8.4/static/pgcrypto.html

But it would be nice to see some of this stuff in core.  I personally
would like a whirlpool hash function.

postgres=# select whirlpool('meow');
                                                            whirlpool

----------------------------------------------------------------------------------------------------------------------------------

bc6145703d25de5cd3fb47f6203d42b2a68b67199ee68bdda84d680900d1147073200ddb87559f5d4d576de76a0cd22e21026a12b3322af4872f34f67d8f642c
(1 row)

Thom

pgsql-novice by date:

Previous
From: "Jean-Yves F. Barbier"
Date:
Subject: md5
Next
From: Mladen Gogala
Date:
Subject: Re: RI