Module jsonb

JSONB table functions.

Statics

_LINKME_ELEMENT_jsonb_array_elements_jsonb_jsonb 🔒

_LINKME_ELEMENT_jsonb_array_elements_text_jsonb_varchar 🔒

_LINKME_ELEMENT_jsonb_each_jsonb_struct_key_varchar_value_jsonb_ 🔒

_LINKME_ELEMENT_jsonb_each_text_jsonb_struct_key_varchar_value_varchar_ 🔒

_LINKME_ELEMENT_jsonb_object_keys_jsonb_varchar 🔒

Functions

jsonb_array_elements 🔒

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

jsonb_array_elements_jsonb_jsonb 🔒

jsonb_array_elements_text 🔒

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

jsonb_array_elements_text_jsonb_varchar 🔒

jsonb_each 🔒

Expands the top-level JSON object into a set of key/value pairs.

jsonb_each_jsonb_struct_key_varchar_value_jsonb_ 🔒

jsonb_each_text 🔒

Expands the top-level JSON object into a set of key/value pairs.

jsonb_each_text_jsonb_struct_key_varchar_value_varchar_ 🔒

jsonb_object_keys 🔒

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

jsonb_object_keys_jsonb_varchar 🔒