FUNCTIONS / JSON FUNCTIONS AND OPERATORS

jsonb_typeof

Returns the type of the top-level JSON value as a text string.

Signatures & examples

jsonb_typeof ( jsonb ) → text

Returns the type of the top-level JSON value as a text string. Possible types are object, array, string, number, boolean, and null. (The null result should not be confused with an SQL NULL; see the examples.)

json_typeof('-123.4') → number

json_typeof('null'::json) → null

json_typeof(NULL::json) IS NULL → t

Version history 3

PG 13 → 14changed
PG 12 → 13changed
PG 9.3 → 9.4added

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