select open change scope Open full search

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

Extensions / Functions and aggregates

pg_row_hashes

Computes deterministic row fingerprints, checksums, and XOR aggregates with SeaHash and FarmHash variants.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagepg_row_hashes
Version0.3.2
PostgreSQL versions17 · 18
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars0
Latest commit2026-06-21
Catalogue updated2026-08-30

Related extensions

See also

scrubBackground worker that scans heaps, B-tree indexes, TOAST data, page structure, and checksums for corruption.
pg_luhnLuhn checksum, validation, and check-digit generation functions.
pgl_validateCross-node data validation for pglogical and PostgreSQL logical replication — lag-correct, contract-aware row-count and checksum verification with sound (zero-false-positive) divergence detection.
hash64Stable 64-bit hash function whose results do not change across PostgreSQL major versions.
pg_bech32Adds Bech32, Bech32m, and no-checksum Bech32 encoding/decoding support to PostgreSQL.
emojigresql🐘 EmojigreSQL: A pure SQL PostgreSQL extension to encode/decode binary data (bytea) and text into colorful emoji sequences! ✨ Includes basic checksum validation.
pgcmpSupport extension for pg_comparator, providing checksum and cast functions for PostgreSQL data comparison.