select open change scope Open full search

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

Extensions / Utilities

pgcompress

Provides deflate, inflate, gzip, and Brotli compression functions for bytea, text, json, and jsonb.

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagepgcompress
Version1.0
RepositoryUnspecified
Extension typeStandard
Project statusUnmaintained
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars3
Latest commit2020-07-17
Catalogue updated2026-08-30

Related extensions

See also

compressC/C++ functions to compress text into Base64-encoded ZIP archives and extract text from them.
jsonbdCompression method for JSONB type
postileA pgrx PostgreSQL extension for map-tile generation helpers and gzip/Brotli bytea compression.
flateRaw DEFLATE compression and decompression functions for bytea
zsonDictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators.
gunzipDecompress gzip-compressed bytea values to text or bytea.
gzipgzip and gunzip functions.
zstdZstandard compression algorithm implementation in PostgreSQL
bzipBzip compression and decompression
pg_lz4LZ4 compression access method for a patched PostgreSQL development branch.