Functions / Json Functions And Operators

jsonb_build_object

Builds a JSON object out of a variadic argument list.

Reading PG 18current·documented in 13 of 27 versions, 9.5 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

jsonb_build_object ( VARIADIC "any" ) → jsonb

Builds a JSON object out of a variadic argument list. By convention, the argument list consists of alternating keys and values. Key arguments are coerced to text; value arguments are converted as per to_json or to_jsonb.

json_build_object('foo', 1, 2, row(3,'bar')) → {"foo" : 1, "2" : {"f1":3,"f2":"bar"}}

Version history 2

12 → 13 changed
9.4 → 9.5 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source