Functions / Binary String Functions And Operators

sha512

Computes the SHA-512 hash of the binary string.

Reading PG 18current·documented in 10 of 27 versions, 11 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

sha512 ( bytea ) → bytea

Computes the SHA-512 hash of the binary string.

sha512('abc'::bytea) → \xddaf35a193617abacc417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a2192992a274fc1a836ba3c23a3feebbd454d4423643ce80e2a9ac94fa54ca49f

Version history 2

12 → 13 changed
10 → 11 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source