Hashing text in hexadecimal

Started by mephystoover 14 years ago3 messagesgeneral
Jump to latest
#1mephysto
mephystoonhell@gmail.com

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?

Thank you very much.

Mephysto

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Hashing-text-in-hexadecimal-tp5022875p5022875.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

#2Tomas Vondra
tomas.vondra@2ndquadrant.com
In reply to: mephysto (#1)
Re: Hashing text in hexadecimal

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.

#3mephysto
mephystoonhell@gmail.com
In reply to: Tomas Vondra (#2)
Re: Hashing text in hexadecimal

Thank you very much.

Meph

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Hashing-text-in-hexadecimal-tp5022875p5022895.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.