On Thu, 11 Sep 2003, Marek Lewczuk wrote:
> I've searched for MD5 crypting function in PG, but I did not find it.
> Anyone knows how to implement this function in PG ?
It's implemented in the pgcrypto module that is in contrib in the tarball.
Once you have added that you can for example do
dennis=# SELECT encode (digest ('the string', 'md5'), 'hex');
44d5a3f30f0328e0cf60cd275ed3aac9
--
/Dennis
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
