How to remove fields from a JSON document in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, and provides two different ways to remove fields from a JSON document:
How to remove nulls JSON object in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the json_strip_nulls (jsonb_strip_nulls for JSONB) function to remove the null values.
How to concatenate two JSON documents in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the opearator || to concatenate two JSON objects.
How to create a JSON object from array of key/value pairs in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from an array of key/value pairs.
How to create a JSON object from keys and values arrays in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_object (jsonb_object for JSONB) to create a JSON object from two arrays of keys and values.
How to convert an array to a JSON array in PostgreSQL
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function array_to_json (array_to_jsonb for JSONB) to create a JSON array from an existing array.
How to build a JSON array from a list of elements in PostgreSQL®
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_build_array (jsonb_build_array for JSONB) to create a JSON array from a list of elements.
How to parse JSON keys in PostgreSQL®
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use several functions to extract the keys and related values in tabular format.
How to convert a table row to JSON in PostgreSQL®?
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function to_json (to_jsonb for JSONB) to convert a table row to a JSON object.
How to prettify the JSON output in PostgreSQL®
PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function json_pretty (jsonb_pretty for JSONB) to prettify the output.
