select open change scope Open full search

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

Extensions / Functions and aggregates

json_utils

JSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+.

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

Overview

Packagepg_json_utils
Version0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars2
Latest commit2023-10-25
Latest release2023-10-25
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pgbsonBSON data type and accessor functions for PostgreSQL
natord_pgNatural-order comparison operators and btree operator class for PostgreSQL text values.
jsonbxJsonb extension functions for PostgreSQL 9.4
parray_ginGIN index operator class and partial-match operators for text arrays
jansson-jsonJSON data type, operators, and functions backed by the Jansson JSON library.
jsquerydata type for jsonb inspection
pgjqUse jq in Postgres
json_fdwForeign data wrapper for local and remote JSON document access.
json_modelJSON Model PL/pgSQL Runtime - JSON value validation
json_buildC functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays.