Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators.
pgext.cloud · Source code · Website · Documentation · License text · Control file
| Package | zson |
|---|---|
| Version | 1.1 |
| Repository | Unspecified |
| Extension type | Standard |
| Vendor | Postgres Professional |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | public |
| Stars | 568 |
| Latest commit | 2023-04-14 |
| Latest release | 2017-06-02 |
| Catalogue updated | 2026-08-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsonbd | Compression method for JSONB type |
| jsquery | data type for jsonb inspection |
| gunzip | Decompress gzip-compressed bytea values to text or bytea. |
| tsvector2 | Compressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. |
| pgjq | Use jq in Postgres |
| pg_deltax | Fast time-series extension for PostgreSQL |
| pg_lz4 | LZ4 compression access method for a patched PostgreSQL development branch. |
| flate | Raw DEFLATE compression and decompression functions for bytea |
| pg_cryogen | Experimental append-only compressed table access method for PostgreSQL 12 and later. |