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

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: how to get the md5 result of a string ?
Date: 2001-09-10 21:15:49
Message-ID: 20010910231549.A2329@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-10 21:16:37 Articles from Computerworld
Previous Message Lamar Owen 2001-09-10 21:09:09 Re: How to make a REALLY FAST db server?