select open change scope Open full search

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

Extensions / Functions and aggregates

json_build

C functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays.

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

Overview

Packagejson_build
Version1.1.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars24
Latest commit2013-10-08
Latest release2013-05-07
Catalogue updated2026-08-30

Related extensions

See also

pgbsonBSON data type and accessor functions for PostgreSQL
json_enhancements_no_hstoreBackport of pg 9.3 JSON enhancements to PostgreSQL 9.2
parray_ginGIN index operator class and partial-match operators for text arrays
numpgsqlArray and numerical computing library for PostgreSQL
jsonb_delete_arrayDelete jsonb keys or string elements listed in a text array
aggs_for_vecsAggregate functions for array inputs
arraymathArray math and operators that work element by element on the contents of arrays
pg_array_multi_indexsimultaneous multiple-indexing of PostgreSQL arrays
array_textsortC functions for sorting and de-duplicating one-dimensional text arrays.
jsquerydata type for jsonb inspection