↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / String Functions And Operators

md5

Read the PG 18 manual

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

Reading PG 18current·documented in 24 of 27 versions, 7.4 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

md5 ( text ) → text
Computes the MD5 hash of the argument, with the result written in hexadecimal.
md5('abc') → 900150983cd24fb0​d6963f7d28e17f72
md5 ( bytea ) → text
Computes the MD5 hash of the binary string, with the result written in hexadecimal.
md5('Th\000omas'::bytea) → 8ab2d3c9689aaf18​b4958c334c82d8b1
Version history 5
  1. 12 → 13 changed
  2. 8.1 → 8.2 changed
  3. 8.0 → 8.1 changed
  4. 7.4 → 8.0 changed
  5. 7.3 → 7.4 added

Definition snapshot: b7bd9cda · English manual source