Contents
sha224()
A function computing a SHA-224 hash
sha224() is a system function for computing the SHA-224 hash of the provided binary string.
sha224() was added in PostgreSQL 11.
Examples
Basic usage example for sha224():
postgres=# SELECT sha224('foo'::bytea);
sha224
------------------------------------------------------------
\x0808f64e60d58979fcb676c96ec938270dea42445aeefcd3a4e6f8db
(1 row)
Return the generated hash as a text string:
postgres=# SELECT encode(sha224('foo'::bytea), 'hex');
encode
----------------------------------------------------------
0808f64e60d58979fcb676c96ec938270dea42445aeefcd3a4e6f8db
(1 row)
References
- PostgreSQL documentation: Other Binary String Functions