Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "playersContainer": {
- "players": [
- {
- "id": "1",
- "name": "Nick",
- "teamName": "Shire Soldiers",
- "ratings": [
- 1,
- 5,
- 6,
- 9
- ],
- "assists": 17,
- "manOfTheMatches": 20,
- "cleanSheets": 1,
- "data": [
- 3,
- 2,
- 3,
- 5,
- 6
- ],
- "totalGoals": 19
- },
- }
- UPDATE site_content
- SET content = jsonb_set(content, '{playersContainer,players}'::text[], content->'playersContainer'->'id'->'players' #- '{1}'::jsonb
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement