Pure PL/pgSQL functions for validating PostgreSQL jsonb documents against JSON Schema draft 4, including use in CHECK constraints.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | postgres-json-schema |
|---|---|
| Version | 0.1.1 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 508 |
| Latest commit | 2023-10-10 |
| Catalogue updated | 2026-08-30 |
| is_jsonb_valid | Native PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7. |
| json_schema_validate | Validate JSON and JSONB data against JSON Schema in PostgreSQL |
| json_validator_ext | Validate JSONB values against JSON Schema using Rust and pgrx |
| pg_jsonschema | PostgreSQL extension providing JSON Schema validation |
| jsonschema | JSON Schema validation functions for PostgreSQL |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| pgx_json_schema | JSON Schema validation for Postgres |
| pg_json_validate | JSON Schema validation functions for jsonb values. |
| jsquery | data type for jsonb inspection |
| pg_registry | Stores and validates JSON Schemas, generates schemas from tables, and binds schemas to Kafka topics. |