Database Tips

Working with a JSONB Array of Objects in PostgreSQL

Get, Add and Remove JSON Objects from an Array

Source: PostgreSQL Wiki

In my last article, we focused on turning a PostgreSQL jsonb column, that contained an Array of Objects, into a recordset, so that it could be queried in a relational manner.

What We Will Do