Extensions / Functions and aggregates
Useful jsonb inspection and transformation functions
pgext.cloud · Source code · Documentation · Control file
| Package | jsonknife |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 11 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 25 |
| Latest commit | 2022-09-21 |
| Catalogue updated | 2026-08-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsquery | data type for jsonb inspection |
| pgjq | Use jq in Postgres |
| zson | Dictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators. |
| jsonb_opx | hstore-style functions and operators for jsonb |
| jsonb_deep_sum | Recursively sum numeric fields in JSONB objects |
| jsonb_extend | Merge two or more jsonb values |
| jsonb_delete | hstore-style delete function and operator for jsonb |