Re: how to get the md5 result of a string ? - Mailing list 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