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/