↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

md5

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

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
string
group label
字符串函数和操作符
lang
en
layout
table-new
pages
functions-string.html, functions-binarystring.html
prose only
false

Definition PG 18

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

Signatures and overloads

md5 ( text ) → text → text
Computes the MD5 hash of the argument, with the result written in hexadecimal.
md5 ( bytea ) → text → text
Computes the MD5 hash of the binary string, with the result written in hexadecimal.

Compare versions

Complete source facts

documentation revision

{"inputs":[{"file":"functions-binarystring.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"cd434063935e362cbb3621171770936b04bafcd58673d71a20cd6992580b2d84","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"dbe9f91e55c35969d99a8d2697b6f7bd5388a24ccc2b89706a666f176025f1e2","version":"18.7"},{"file":"functions-binarystring.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"a5ee5be3c79e45371853d5c6dd8b1b3f52734bbc17726dbe626837179a1da1e0","version":"18.7"},{"file":"functions-string.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"7eecd3bb343149124be0476a539f3c682476eab2a15489a0e0ad06fbb769ea9e","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:3b77cfb0e4c18173b498900a2884b178e7d20c9c44e9e820aadd07fcff7799c5

Text language: en · wiki-repair-20261023:3b77cfb0e4c18173b498900a2884b178e7d20c9c44e9e820aadd07fcff7799c5