FUNCTIONS / JSON FUNCTIONS AND OPERATORS

jsonb_array_elements_text

Expands the top-level JSON array into a set of text values.

Signatures & examples

jsonb_array_elements_text ( jsonb ) → setof text

Expands the top-level JSON array into a set of text values.

select * from json_array_elements_text('["foo", "bar"]') →    value
-----------
 foo
 bar

Version history 2

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