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

[Marko Kreen]

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


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

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