Thread: how to get the md5 result of a string ?
Hi, Is there a function like: select md5(<attribute_name>) from .... Thanks, -- Feite Brekeveld feite.brekeveld@osiris-it.nl http://www.osiris-it.nl
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
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