ftisiot ideas about food and life
who talks suggestions soft json-pg

How to convert an array to a JSON array in PostgreSQL

Published Jan 9, 2023 by in Postgresql, Json, Jsonb, Convert, Array at https://ftisiot.net/postgresqljson/howto-convert-array-to-json-array-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.

NOTE: To review the differences between JSON and JSONB check out the related article.

NOTE: more info is available in the PostgreSQL JSON functions documentation page

Convert an array to a JSON array with the array_to_json function

You can convert an array to a JSON array with the array_to_json (array_to_jsonb for JSONB) function

select array_to_json(
        ARRAY['🍌', '🌶️', '🍍']);

Result

  array_to_json
-----------------
 ["🍌","🌶️","🍍"]
(1 row)

Review all the JSON PostgreSQL use-cases listed in the main page


Francesco Tisiot

Mastodon Francesco comes from Verona, Italy and works as a Senior Developer Advocate at Aiven. With his many years of experience as a data analyst, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!

Story logo

© 2023