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/