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.
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.