md5()

Computes the MD5 hash of the argument, with the result written in hexadecimal.

Signature

md5 ( text ) → text

Examples

SELECT md5('abc');

900150983cd24fb0d6963f7d28e17f72

Run against PostgreSQL 18.6 on 2026-09-13. This is the output we got, not the documentation’s.

In other engines

PostgreSQL	md5
MySQL	MD5(x)
SQL Server	CONVERT(varchar(32), HASHBYTES('MD5', x), 2)
Oracle	STANDARD_HASH(x, 'MD5')
SQLite	no direct equivalent

SQL Server returns binary and needs the style-2 CONVERT to read as hex; SQLite has no hash functions in the core build at all.

Want to run this against your own PostgreSQL server from an iPhone, iPad or Mac? These are ours — every connection goes straight from the device to your database, with no account and no server of ours in between.

Postgres & FriendsPostgreSQL and the open-source engines around it

Signature and description adapted from the PostgreSQL manual, used under the PostgreSQL License. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. This page is not affiliated with the PostgreSQL Global Development Group.