that it is a valid JSON string. to_json('Fr ed said "Hi."'::tex t) "Fred said \"Hi.\"" array_to_js on(anyarray [, pretty_bool ]) Returns the array as a JSON array. A multidimensional array becomes of arrays. Line feeds will be added between dimension-1 elements if pretty_bool is true. array_to_js on('{{1,5}, {99,100}}': :int[]) [[1,5], [99,100]] Note: The != operator is converted to <> in json_each('{"a":"foo ", "b":"bar"}') key | value -----+------- a | "foo" b | "bar" json_each_text(js on) jsonb_each_text(j sonb) setof key text, value text Expands the outermost JSON object into

that it is a valid JSON string. to_json('Fr ed said "Hi."'::tex t) "Fred said \"Hi.\"" array_to_js on(anyarray [, pretty_bool ]) Returns the array as a JSON array. A multidimensional array becomes of arrays. Line feeds will be added between dimension-1 elements if pretty_bool is true. array_to_js on('{{1,5}, {99,100}}': :int[]) [[1,5], [99,100]] Note: The != operator is converted to <> in the json_each('{"a":"foo ", "b":"bar"}') key | value -----+------- a | "foo" b | "bar" json_each_text(js on) jsonb_each_text(j sonb) setof key text, value text Expands the outermost JSON object into

that it is a valid JSON string. to_json('Fr ed said "Hi."'::tex t) "Fred said \"Hi.\"" array_to_js on(anyarray [, pretty_bool ]) Returns the array as a JSON array. A multidimensional array becomes of arrays. Line feeds will be added between dimension-1 elements if pretty_bool is true. array_to_js on('{{1,5}, {99,100}}': :int[]) [[1,5], [99,100]] Note: The != operator is converted to <> in the json_each('{"a":"foo ", "b":"bar"}') key | value -----+------- a | "foo" b | "bar" json_each_text(js on) jsonb_each_text(j sonb) setof key text, value text Expands the outermost JSON object into

json_extract_path_text ('{"f2":{"f3":1},"f4": {"f5":99,"f6":"foo"}}' ,'f4', 'f6') foo json_object_keys(js on) jsonb_object_keys(j sonb) setof text Returns set of keys in the outermost JSON object. that it is a valid JSON string. to_json('Fr ed said "Hi."'::tex t) "Fred said \"Hi.\"" array_to_js on(anyarray [, pretty_bool ]) Returns the array as a JSON array. A multidimensional array becomes of arrays. Line feeds will be added between dimension-1 elements if pretty_bool is true. array_to_js on('{{1,5}, {99,100}}': :int[]) [[1,5], [99,100]] row_to_json (record [, pretty_bool ]) Returns

is contained: SELECT '{"foo": {"bar": "baz", "zig": "zag"}}'::jsonb @> '{"foo": {"bar": "baz"}}'::js onb; VMware Greenplum 6 Documentation VMware by Broadcom 826 The general principle is that the key | value -----+------ - a | "foo" b | "bar" json_each_text(jso n) jsonb_each_text(js onb) setof key text, value text Expands the outermost JSON object into a set of key/value pairs 835 Function Return Type Description Example Example Result json_to_record(jso n) jsonb_to_record(js onb) record Builds an arbitrary record from a JSON object. See Note 1. As with all functions

is contained: SELECT '{"foo": {"bar": "baz", "zig": "zag"}}'::jsonb @> '{"foo": {"bar": "baz"}}'::js onb; The general principle is that the contained object must match the containing object as to structure key | value -----+------ - a | "foo" b | "bar" json_each_text(jso n) jsonb_each_text(js onb) setof key text, value text Expands the outermost JSON object into a set of key/value pairs boolean, and null. See Note 2. json_typeof('-123.4') number json_to_record(jso n) jsonb_to_record(js onb) record Builds an arbitrary record from a JSON object. See Note 1. As with all functions returning

it is contained: SELECT '{"foo": {"bar": "baz", "zig": "zag"}}'::jsonb @> '{"foo": {"bar": "baz"}}'::js onb; VMware Greenplum 6 Documentation VMware, Inc. 797 The general principle is that the contained key | value -----+------ - a | "foo" b | "bar" json_each_text(jso n) jsonb_each_text(js onb) setof key text, value text Expands the outermost JSON object into a set of key/value pairs 806 Function Return Type Description Example Example Result json_to_record(jso n) jsonb_to_record(js onb) record Builds an arbitrary record from a JSON object. See Note 1. As with all functions

it is contained: SELECT '{"foo": {"bar": "baz", "zig": "zag"}}'::jsonb @> '{"foo": {"bar": "baz"}}'::js onb; VMware Greenplum 6 Documentation VMware, Inc 817 The general principle is that the contained json_extract_path_text ('{"f2":{"f3":1},"f4": {"f5":99,"f6":"foo"}}' ,'f4', 'f6') foo json_object_keys(js on) jsonb_object_keys(j sonb) setof text Returns set of keys in the outermost JSON object. js "b":"bar"}') key | value -----+------ - a | "foo" b | "bar" json_each_text(jso n) jsonb_each_text(js onb) setof key text, value text Expands the outermost JSON object into a set of key/value pairs

it is contained: SELECT '{"foo": {"bar": "baz", "zig": "zag"}}'::jsonb @> '{"foo": {"bar": "baz"}}'::js onb; The general principle is that the contained object must match the containing object as to structure json_extract_path_text (‘{“f2”: {“f3”:1},“f4”: {“f5”:99,“f6”:“foo ”}}’,‘f4’, ‘f6’) foo json_object_keys(js on) jsonb_object_keys(j sonb) setof text Returns set of keys in the outermost JSON object. json_object_keys(‘{“ “b”:“bar”}’) key | value —–+——- a | “foo” b | “bar” json_each_text(jso n) jsonb_each_text(js onb) setof key text, value text Expands the outermost JSON object into a set of key/value pairs

“b”:“bar”}’) key | value —–+——- a | “foo” b | “bar” json_each_text(jso n) jsonb_each_text(js onb) setof key text, value text Expands the outermost JSON object into a set of key/value pairs