Uses the MD5 cryptographic hash function to convert a variable-length string into a 32-character string that is a text representation of the hexadecimal value of a 128-bit checksum.
Syntax
MD5(string)
Arguments
- string
-
A variable-length string.
Return type
The MD5 function returns a 32-character string that is a text representation of the hexadecimal value of a 128-bit checksum.
Examples
The following example shows the 128-bit value for the string 'Amazon Redshift':
select md5('Amazon Redshift');
md5
----------------------------------
f7415e33f972c03abd4f3fed36748f7a
(1 row)
