FIND YOUR NEXT FEW LINES
Results for “json_each”
Small, practical examples. Search by task or narrow things down below.
231 snippets foundClear filters
Expand a JSON array into rows
Iterate array elements using a table-valued function.
json_each✓ Tested
Build a JSON array from rows
Aggregate ordered text values into JSON.
json_group_array✓ Tested
Check JSONB containment
Test whether an object contains a key-value pair.
jsonb✓ Tested
Check whether text is valid JSON
Reject malformed input before processing it.
json_valid✓ Tested
Extract a JSON field
Read a scalar value from JSON text.
json_extract✓ Tested
Read a JSONB field as text
Extract a nested value from a JSON document.
jsonb✓ Tested
Replace a nested JSONB value
Change one path with jsonb_set.
jsonb_set✓ Tested
Set a JSON property
Create an updated JSON document from existing text.
json_set✓ Tested
Collect ordered values into an array
Build a sorted array from query rows.
array_agg✓ Tested
Expand an array into rows
Use WITH ORDINALITY to retain original element order.
unnest✓ Tested
Read CSV rows as dictionaries
Read a CSV file using its header row as dictionary keys, so each column can be accessed by name.
csv✓ Tested
Assign a rank within each group
Number rows with a partitioned window.
ROW_NUMBER✓ Tested