PostgreSQL Tutorial: MD5 Function

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