select open change scope Open full search

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

Extensions / Data types

jsonb_schema

jsonb with separately stored schema

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

Overview

Packagejsonb_schema
Version1.0
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars5
Latest commit2020-08-24
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pgbsonBSON data type and accessor functions for PostgreSQL
jsquerydata type for jsonb inspection
pgjqUse jq in Postgres
is_jsonb_validNative PostgreSQL extension for validating jsonb values against JSON Schema draft 4 and draft 7.
zsonDictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators.
jsonb_opxhstore-style functions and operators for jsonb
jsonb_extendMerge two or more jsonb values
jsonb_deletehstore-style delete function and operator for jsonb