Functions / Json Functions And Operators

json_array_elements_text

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

Reading PG 18current·documented in 14 of 27 versions, 9.4 to 20

Signatures & examples

json_array_elements_text ( json ) → 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