Adding more data in array of object in PostgreSQL

Question

I have a table of cart with 2 columns (user_num, data).

user_num will have the phone number of user and data will have an array of object like [{ "id": 1, "quantity": 1 }, { "id": 2, "quantity": 2 }, { "id": 3, "quantity": 3 }] here id is product id.

 user_num |                                         data
----------+--------------------------------------------------------------------------------------
        1 | [{ "id": 1, "quantity": 1 }, { "id": 2, "quantity": 2 }, { "id": 3, "quantity": 3 }]

I want to add more data of products in above array of objects in PostgreSQL.

Thanks!

Which kind type of column data? Is it JSON or JSONB? — Pooya
– Pooya, Commented Dec 15, 2021 at 6:25

Pooya · Accepted Answer · 2021-12-15 06:42:44Z

1

To add the value use the JSONB array append operator ||

Demo

update
  test
set
  data = data || '[{"id": 4, "quantity": 4}, {"id": 5, "quantity": 5}]'
where
  user_num = 1;

answered Dec 15, 2021 at 6:42

Pooya

3,2032 gold badges16 silver badges21 bronze badges

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

2 Comments

Samir Over a year ago

two more questions, How will I delete an object where id is 4 and How will I edit quantity?

Pooya Over a year ago

I hope this sample helps you. I append a sample for updating and deleting property in the array. dbfiddle.uk/…

Collectives™ on Stack Overflow

Adding more data in array of object in PostgreSQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related