{"Entry":{"collection":"func","key":"sha256","name":"sha256","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"10","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"11"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"}],"content_hash":"f3a3ee4f8c3447353dbb885b19746a1a1681e983b7a764562da5d09fb6c6cffb","derived_content_hash":"8ffecba5137acfa15a58f84d26cc60497df2491c86110291d7b3b2320e712b9b","first_version":"11","group":"binarystring","group_label":"Binary String Functions And Operators","groups":["binarystring"],"imported_at":"2026-09-14T21:49:48.689067+08:00","last_version":"20","name":"sha256","name_key":"sha256","position":4013,"present_in":["11","12","13","14","15","16","17","18","19","20"],"repair_provenance":{"original_source_revision":"wiki-repair-20261023:c03012e001c4287f11197fcdf65126313d49f45e0e82cc46daa07aa812aaa259","receipt_sha256":"17d67938ec4c7be6a62202c8729df1437aab7ab2ca27ed1c0026813e5ec15c98","repair":"wiki-repair-20261023"},"signature":"sha256 ( bytea ) → bytea","signature_count":1,"slug":"sha256","source_rev":"wiki-repair-20261023:f9905fe41655242d2046961e6226f24762ff4fa1ba0cfe1b4d1d8ae59f258db0","summary":"Computes the SHA-256 hash of the binary string.","summary_zh":""}},"Definition":{"Collection":"func","Key":"sha256","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"sha256","SourceRevision":"wiki-repair-20261023:f9905fe41655242d2046961e6226f24762ff4fa1ba0cfe1b4d1d8ae59f258db0","Facts":{"description":"Computes the SHA-256 hash of the binary string.","description_html":"Computes the SHA-256 \u003ca href=\"/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e of the binary string.","description_zh":"计算二进制字符串的 SHA-256 hash。","description_zh_html":"计算二进制字符串的 SHA-256 \u003ca href=\"/zh/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e。","doc":{"anchor":"FUNCTIONS-BINARYSTRING-OTHER","file":"functions-binarystring.html","slug":"18"},"group":"binarystring","group_label":"Binary String Functions And Operators","lang":"en","layout":"table-new","pages":["functions-binarystring.html"],"prose_only":false,"signatures":[{"description":"Computes the SHA-256 hash of the binary string.","description_html":"Computes the SHA-256 \u003ca href=\"/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e of the binary string.","description_zh":"计算二进制字符串的 SHA-256 hash。","description_zh_html":"计算二进制字符串的 SHA-256 \u003ca href=\"/zh/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e。","examples":[{"expr":"sha256('abc'::bytea)","result":"\\xba7816bf8f01cfea414140de5dae2223​b00361a396177a9cb410ff61f20015ad"}],"html":"\u003ccode class=\"function\"\u003esha256\u003c/code\u003e ( \u003ccode class=\"type\"\u003ebytea\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebytea\u003c/code\u003e","returns":"bytea","text":"sha256 ( bytea ) → bytea","zh_from":"same-version-pgdoc"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-binarystring.html","sha256":"a98a1aec8735ec5efda751ce6130ddf7f9294aa38d0c0572205fff95132250b9"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-BINARYSTRING-OTHER","file":"functions-binarystring.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"sha256","SourceDatabase":"center","Version":"18","Locale":"en","Title":"sha256","Summary":"Computes the SHA-256 hash of the binary string.","BodyHTML":"Computes the SHA-256 \u003ca href=\"/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\" rel=\"nofollow\"\u003ehash\u003c/a\u003e of the binary string.","SourceRevision":"wiki-repair-20261023:f9905fe41655242d2046961e6226f24762ff4fa1ba0cfe1b4d1d8ae59f258db0","ContentHash":"6309a068956ee04e59e916be2538adb78eb6a2c144e7b6be68a84eb3cd17912f","Payload":{"description":"Computes the SHA-256 hash of the binary string.","description_html":"Computes the SHA-256 \u003ca href=\"/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e of the binary string.","signatures":[{"description":"Computes the SHA-256 hash of the binary string.","description_html":"Computes the SHA-256 \u003ca href=\"/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e of the binary string.","description_zh":"计算二进制字符串的 SHA-256 hash。","description_zh_html":"计算二进制字符串的 SHA-256 \u003ca href=\"/zh/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e。","examples":[{"expr":"sha256('abc'::bytea)","result":"\\xba7816bf8f01cfea414140de5dae2223​b00361a396177a9cb410ff61f20015ad"}],"html":"\u003ccode class=\"function\"\u003esha256\u003c/code\u003e ( \u003ccode class=\"type\"\u003ebytea\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebytea\u003c/code\u003e","returns":"bytea","text":"sha256 ( bytea ) → bytea","zh_from":"same-version-pgdoc"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"4a8c117222e0319411943b0195b4b0bc05f31255210f0a62a2915e627d8ed92c","Text":"sha256 ( bytea ) → bytea","Returns":"bytea","Payload":{"description":"Computes the SHA-256 hash of the binary string.","description_html":"Computes the SHA-256 \u003ca href=\"/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e of the binary string.","description_zh":"计算二进制字符串的 SHA-256 hash。","description_zh_html":"计算二进制字符串的 SHA-256 \u003ca href=\"/zh/docs/18/functions-binarystring.html#FUNCTIONS-HASH-NOTE\"\u003ehash\u003c/a\u003e。","examples":[{"expr":"sha256('abc'::bytea)","result":"\\xba7816bf8f01cfea414140de5dae2223​b00361a396177a9cb410ff61f20015ad"}],"html":"\u003ccode class=\"function\"\u003esha256\u003c/code\u003e ( \u003ccode class=\"type\"\u003ebytea\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003ebytea\u003c/code\u003e","returns":"bytea","text":"sha256 ( bytea ) → bytea","zh_from":"same-version-pgdoc"}}],"Spellings":null,"SQLState":null,"Evidence":null}
