PostgreSQL/Math Functions/md5

Calculates the MD5 hash of string, returning the result in hexadecimal

postgres=#
postgres=# -- md5(string)
postgres=# --Calculates the MD5 hash of string, returning the result in hexadecimal
postgres=# select md5("A\\000oB"::bytea);
               md5
----------------------------------
 1160190c6528db499b50394519f167c4
(1 row)
postgres=#