append
remove
nested append
Splice by index
Splice by index of object array
itectec.com
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.
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
