Calculates the MD5 hash of string, returning the result in hexadecimal : md5 « Math Functions « PostgreSQL

1. PostgreSQL
2. Math Functions
3. 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=#

           
       

Related examples in the same category