From: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: Chad Wagner <chad.wagner@gmail.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: SHA-1 vs MD5
Date: Thu, 8 Mar 2007 08:39:26 -0300
Message-ID: <55c095e90703080339y67152f49ud82741fd21ac6370@mail.gmail.com> (raw)
In-Reply-To: <81961ff50703071344i28d9ea6cr4902fed404b38602@mail.gmail.com>
References: <55c095e90703071204t5aebb921s9d5f1067d3c2f035@mail.gmail.com>
<81961ff50703071344i28d9ea6cr4902fed404b38602@mail.gmail.com>
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.wagner@gmail.com>:
>
> On 3/7/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ezequias.rocha@gmail.com, chad.wagner@gmail.com
Subject: Re: SHA-1 vs MD5
In-Reply-To: <55c095e90703080339y67152f49ud82741fd21ac6370@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox