Python: Update data

• update() should always be combined with Filters to target the item(s) you wish to update.

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.

• returning

  (Optional)

  Either 'minimal' or 'representation'. Defaults to 'representation'.

• ignore_duplicates

  (Optional)

  Whether duplicate rows should be ignored.

• on_conflict

  (Optional)

  Specified columns to be made to work with UNIQUE constraint.

• default_to_null

  (Optional)

  Make missing fields default to `null`. Otherwise, use the default value for the column. This only applies when inserting new rows, not when merging with existing rows under `ignore_duplicates: false`. This also only applies when doing bulk upserts.

Examples

Updating your data

response = (
    supabase.table("countries")
    .update(\{"name": "Australia"\})
    .eq("id", 1)
    .execute()
)

Updating JSON data

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