Functions / Json Functions And Operators

json_object_keys

Returns the set of keys in the top-level JSON object.

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

Signatures & examples

json_object_keys ( json ) → setof text

Returns the set of keys in the top-level JSON object.

select * from json_object_keys('{"f1":"abc","f2":{"f3":"a", "f4":"b"}}') →  json_object_keys
------------------
 f1
 f2

Version history 3

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