Re: SHA-1 vs MD5

I really don't have the pgcrypto. It could be a nice alternative. Could you
tell me the steps to install it ?

I am very concerned about security in my application becouse we are going to
moviment a large ammount of information and money. As much i take care of it
as good.

I know some problem of MD5 and know it is very good too. If someone could
tell me where MD5 is used I could be more relaxed.

My best regards to all

--
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev.org/firefox/

2007/3/7, Chad Wagner <chad(dot)wagner(at)gmail(dot)com>:
>
> On 3/7/07, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com> wrote:
> >
> > I know that there is a md5 internal function on postgresql, but I
> > noticed that it isn't the more secure today. I would like to know if there
> > is a SHA-1 function implemented yet of, if not, if the team has plan to
> > introduce it on PostgreSQL.
>
>
> You are probably looking for the pgcrypto contribution, look in the
> contrib directory for it.
>
> test=# select encode(digest('blahblah', 'sha256'), 'hex');
> encode
> ------------------------------------------------------------------
> 40b1bbb5445fc021a312315379f4633284851e14d1db83fb0730f58872d6033b
> (1 row)
>
>
>
>
> --
> Chad
> http://www.postgresqlforums.com/