Functions / Json Functions And Operators

json_extract_path_text

Extracts JSON sub-object at the specified path as text.

Reading PG 18current·documented in 15 of 27 versions, 9.3 to 20

Signatures & examples

json_extract_path_text ( from_json json, VARIADIC path_elems text[] ) → text

Extracts JSON sub-object at the specified path as text. (This is functionally equivalent to the #>> operator.)

json_extract_path_text('{"f2":{"f3":1},"f4":{"f5":99,"f6":"foo"}}', 'f4', 'f6') → foo

Version history 3

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