Postgre JSONB Array

append

remove

nested append

Splice by index

Splice by index of object array

I am attempting to remove an element from my database. The element I want to remove is within a JSON object called playerContainer which contains an array named players. This all sits within a table called site_content. I am trying to remove the object based on it's ID.

itectec.com

https://itectec.com/database/postgresql-delete-an-object-from-within-an-array-using-jsonb-in-postgresql/

Append and remove simple

Appending (pushing) and removing from a JSON array in PostgreSQL 9.5+

For versions less than 9.5 see this question I have created a table in PostgreSQL using this: CREATE TEMP TABLE jsontesting AS SELECT id, jsondata::jsonb FROM ( VALUES (1, '["abra","value",...

https://stackoverflow.com/questions/42233542/appending-pushing-and-removing-from-a-json-array-in-postgresql-9-5

Recommendations

///////////