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 <[EMAIL PROTECTED]>:
On 3/7/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> 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/