Re: how to get the md5 result of a string ?

Started by Marko Kreenover 24 years ago2 messagesgeneral

Jump to latest

Marko Kreen

markokr@gmail.com

over 24 years ago

On Mon, Sep 10, 2001 at 11:40:27PM +0200, Feite Brekeveld wrote:

Is there a function like:

select md5(<attribute_name>) from ....

digest(field, 'md5')

If you want in hex:

encode(digest(field, 'md5'), 'hex')

Look into contrib/pgcrypto in PostgreSQL source.

--
marko

Import Notes

Reply to msg id not found: 3B9D334B.AE9DDC2E@osiris-it.nl

Bruce Momjian

bruce@momjian.us

over 24 years ago

In reply to: Marko Kreen (#1)

Yes see /contrig/pgcrypto.

Hi,

Is there a function like:

select md5(<attribute_name>) from ....

Thanks,

--
Feite Brekeveld
feite.brekeveld@osiris-it.nl
http://www.osiris-it.nl

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Import Notes

Reply to msg id not found: 3B9D334B.AE9DDC2E@osiris-it.nl | Resolved by subject fallback