Extensions / Functions and aggregates
JSONB diff, JSON Patch, and merge-patch functions for PostgreSQL
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_json_diff |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 1 |
| Latest commit | 2025-11-14 |
| Catalogue updated | 2026-08-30 |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| jsonb_extend | Merge two or more jsonb values |
| jsquery | data type for jsonb inspection |
| pgjq | Use jq in Postgres |
| pg-audit-json | Trigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs. |
| pgrx_jsonb | Proof-of-concept pgrx functions for iterating PostgreSQL JSONB internals and reconstructing JSON values |
| pg_simdjson | Prototype SIMD-accelerated parser that converts JSON text to jsonb |
| is_jsonb_valid | Native PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7. |