© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
1 reply
w3mw

Update json file from define as array?

Hello, I have a table, where I have a column call teams with json[] (defined as array).

I know that I can insert json to it. But is it possible to update an object inside that array in that json file?

[
  {
    "id": 1,
    "name": "Arsenal",
    "url": "https://icons.iconarchive.com/icons/giannis-zographos/english-football-club/256/Arsenal-FC-icon.png"
  },
  {
    "id": 2,
    "name": "Chelsea",
    "url": "https://icons.iconarchive.com/icons/giannis-zographos/english-football-club/256/Chelsea-FC-icon.png"
  },]
[
  {
    "id": 1,
    "name": "Arsenal",
    "url": "https://icons.iconarchive.com/icons/giannis-zographos/english-football-club/256/Arsenal-FC-icon.png"
  },
  {
    "id": 2,
    "name": "Chelsea",
    "url": "https://icons.iconarchive.com/icons/giannis-zographos/english-football-club/256/Chelsea-FC-icon.png"
  },]


So If I would like to update the seconds object, id 2 to name "United" instead of Chelsea, is that possible?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Alternative to storing JSON array
SupabaseSSupabase / help-and-questions
4y ago
Empty array as response
SupabaseSSupabase / help-and-questions
4y ago
Insert or delete only one value from json array in table.
SupabaseSSupabase / help-and-questions
4y ago
Integer array showing up as text?
SupabaseSSupabase / help-and-questions
4y ago