From: Chad Wagner <chad.wagner@gmail.com>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: SHA-1 vs MD5
Date: Wed, 7 Mar 2007 16:44:39 -0500
Message-ID: <81961ff50703071344i28d9ea6cr4902fed404b38602@mail.gmail.com> (raw)
In-Reply-To: <55c095e90703071204t5aebb921s9d5f1067d3c2f035@mail.gmail.com>
References: <55c095e90703071204t5aebb921s9d5f1067d3c2f035@mail.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: chad.wagner@gmail.com, ezequias.rocha@gmail.com
Subject: Re: SHA-1 vs MD5
In-Reply-To: <81961ff50703071344i28d9ea6cr4902fed404b38602@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