select open change scope Open full search

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

Extensions / Data types

sha

This module provides datatypes for storing SHA-1, SHA-2 and MD5 hashes

pgext.cloud · Documentation · PGXN

Overview

Packagesha
Version1.1.0
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
Catalogue updated2026-07-30

Related extensions

See also

hashtypessha1, md5 and other data types for PostgreSQL
md5hashtype for storing 128-bit binary data inline
pg_etagFast ETag generation for rows and result sets using BLAKE2 hashes, with single-input functions and aggregates.
hashlibStable hash functions for Postgres
fnvhashFNV hash functions for PostgreSQL.
vihashversion-independent hash functions
pg_tamperlog_rustRust pgrx helper extension for pg_tamperlog fast SHA-256 hash-chain calculations.
check_chapmd5_passwordFunction for verifying CHAP-MD5 authentication responses.