Skip to main content

PostgreSQL MD5() Function

The PostgreSQL MD5() function calculates the MD5 hash of a string and returns the result in hexadecimal.

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.