PostgreSQL 9.4: How to Convert JSON ARRAY Elements into String ARRAY

I have already written a couple of articles about the PostgreSQL JSON Data type and its different type of operations.

PostgreSQL 9.4: The JSON data type is Awesome (Part 1/3)

PostgreSQL: How to convert Table Data into JSON formatted Data?

In this post, I am going to share one more demonstration about PostgreSQL JSON.

In our system, I have stored communication message information in the form of JSON. This JSON column contains lots of different types of elements.
Now one of module required to fetch this JSON array elements into a form of STRING Array only. (Something like comma separated).

We have different type of JSON functions and operator so I have achieved this solution using jsonb_array_elements.

Below is a full demonstration of this:

Create one table with sample data:

SQL Query to convert JSON elements into String Array:

The Result:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz