md5 ( text ) → text → textComputes the MD5 hash of the argument, with the result written in hexadecimal.
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 ( bytea ) → text → textComputes 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