Python: Update data

• update() should always be combined with Filters to target the item(s) you wish to update.
• Chain .select() after update() to return specific columns from the updated row(s).

Parameters

• json

  (Required)

  The values to insert. Pass an dict to insert a single row or an list to insert multiple rows.

• count

  (Optional)

  The property to use to get the count of rows returned.

Examples

Updating your data

response = (
    supabase.table("instruments")
    .update({"name": "piano"})
    .eq("id", 1)
    .execute()
)

Updating JSON data

response = (
    supabase.table("users")
    .update({"address": {"street": "Melrose Place", "postcode": 90210}})
    .eq("address->postcode", 90210)
    .execute()
)

Update and return selected columns

response = (
    supabase.table("instruments")
    .update({"name": "piano"})
    .eq("id", 1)
    .select("id, name")
    .execute()
)