September 19, 2023
Summary: The PostgreSQL MD5() function calculates the MD5 hash of a string and returns the result in hexadecimal.
Table of Contents
Syntax
The following illustrates the syntax of the MD5() function:
MD5(string)
Arguments
The MD5() function accepts one argument.
1) string
The string argument is the string of which the MD5 hash is calculated.
Return value
The MD5() function returns a string in TEXT data type.
Examples
The following example shows how to use the MD5() function to return the MD5 hash of the message 'PostgreSQL MD5':
SELECT MD5('PostgreSQL MD5');
The result is:
md5
----------------------------------
f78fdb18bf39b23d42313edfaf7e0a44
(1 row)
In this tutorial, you have learned how to use the PostgreSQL MD5() function to calculate the MD5 hash of a string.
See more
PostgreSQL Tutorial: String Functions
PostgreSQL Documentation: String Functions and Operators