Functions / Json Functions And Operators

json_extract_path

Extracts JSON sub-object at the specified path.

Reading PG 18current·documented in 15 of 27 versions, 9.3 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

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

Extracts JSON sub-object at the specified path. (This is functionally equivalent to the #> operator, but writing the path out as a variadic list can be more convenient in some cases.)

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

Version history 3

12 → 13 changed
9.3 → 9.4 changed
9.2 → 9.3 added

Definition snapshot: b7bd9cda · English manual source