Re: Hashing text in hexadecimal - Mailing list pgsql-general

From Tomas Vondra
Subject Re: Hashing text in hexadecimal
Date
Msg-id 39b6624e579b68374c0bdd88b4f3fa42.squirrel@sq.gransy.com
Whole thread Raw
In response to Hashing text in hexadecimal  (mephysto <mephystoonhell@gmail.com>)
Responses Re: Hashing text in hexadecimal  (mephysto <mephystoonhell@gmail.com>)
List pgsql-general
On 25 Listopad 2011, 15:15, mephysto wrote:
> Hello to everyone,
> I would need to hash some text and I would to produce an hexadecimal value
> as result.
>
> Is there a postgres function to achieve this goal?

What about md5(text)? If you need better hashing (e.g. sha-1), check
pgcrypto contrib module.

T.


pgsql-general by date:

Previous
From: mephysto
Date:
Subject: Hashing text in hexadecimal
Next
From: Yeb Havinga
Date:
Subject: Re: Recommendations for SSDs in production?