Psql query to convert array of json into rows

Question

I have an array of json -

[{id:1,quantity:100},{id:2,quantity:25},{id:3,quantity:68}]

How do convert this into following using query in postgres -

Id     |Quantity
-----------------
1      |100
2      |25
3      |68

If it is at all possible, I want to know how

user330315 · Accepted Answer · 2019-02-18 11:57:23Z

2

Use jsonb_array_elements()

select t ->> 'id' as id, t ->> 'quantity' as quantity
from jsonb_array_elements('[{"id":1,"quantity":100},{"id":2,"quantity":25},{"id":3,"quantity":68}]') as t

Online example: https://rextester.com/YBUER58387

answered Feb 18, 2019 at 11:57

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Psql query to convert array of json into rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related