Postgres Pro
Downloads
Home   >   mailing lists

Re: SHA-1 vs MD5 - Mailing list pgsql-sql

From Chad Wagner
Subject Re: SHA-1 vs MD5
Date
Msg-id 81961ff50703071344i28d9ea6cr4902fed404b38602@mail.gmail.com
Whole thread Raw
In response to SHA-1 vs MD5  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
Responses Re: SHA-1 vs MD5  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
Tree view
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/

pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tesearch2 question
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Re: SHA-1 vs MD5