info

The MD5() function works the same across any PostgreSQL deployment, so what you learn here applies whether you're running Postgres on your laptop, a managed service, or a cloud platform. If you're an enterprise looking for managed Postgres built for the AI era, Lakebase delivers the performance, security, and native Lakehouse integration you need. If you're a developer or startup who needs to ship and scale fast, Neon gives you the best Postgres platform for moving quickly.

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.