Expand description
JSONB support
Modules§
- array_
elements - expand array into value rows
- array_
length - array length
- cast
- type conversions
- each
- expand object into key-value rows
- extract
- shared JSONB extraction helpers (used by
each/array_elementsandlist_udfs) Shared JSONB extraction helpers, used by both thejsonb_each/jsonb_array_elementsUDTFs and the list-returning scalar UDFs (jsonb_entries,jsonb_elements,jsonb_path_elements). - format_
json - jsonb->json
- get
- get by name
- keys
- extract object keys
- list_
udfs - list-returning scalar UDFs: jsonb_entries, jsonb_elements, jsonb_path_elements
List-returning JSONB scalar UDFs:
jsonb_entries,jsonb_elements,jsonb_path_elements. - parse
- jsonb_parse
- path_
query - JSONPath query
Structs§
- Jsonb
Array Length - A scalar UDF that returns the number of elements in a JSONB array.
- Jsonb
AsF64 - A scalar UDF that casts a JSONB value to a f64.
- Jsonb
AsI64 - A scalar UDF that casts a JSONB value to an i64.
- Jsonb
AsString - A scalar UDF that casts a JSONB value to a string.
- Jsonb
Elements - A scalar UDF that expands a JSONB array into a list of its elements.
- Jsonb
Entries - A scalar UDF that expands a JSONB object or array into a list of
{key, value}entries. - Jsonb
Format Json - A scalar UDF that formats JSONB binary data as a JSON string.
- Jsonb
Get - A scalar UDF that retrieves a value from a JSONB object by name.
- Jsonb
Object Keys - A scalar UDF that extracts the keys from a JSONB object.
- Jsonb
Parse - A scalar UDF that parses a JSON string into a JSONB value.
- Jsonb
Path Elements - A scalar UDF that expands all matches of a JSONPath expression on a JSONB value into a list.
- Jsonb
Path Query - A scalar UDF that returns all matches of a JSONPath expression on a JSONB value as a JSONB array.
- Jsonb
Path Query First - A scalar UDF that returns the first match of a JSONPath expression on a JSONB value.