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.