Re: Hashing text in hexadecimal

From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: "mephysto" <mephystoonhell(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hashing text in hexadecimal
Date: 2011-11-25 14:18:41
Message-ID: 39b6624e579b68374c0bdd88b4f3fa42.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yeb Havinga 2011-11-25 14:18:42 Re: Recommendations for SSDs in production?
Previous Message mephysto 2011-11-25 14:15:35 Hashing text in hexadecimal