Modify data: update()

Performs an UPDATE on the table.

const { data, error } = await supabase
.from('cities')
.update({ name: 'Middle Earth' })
.match({ name: 'Auckland' })

Parameters

  • valuesrequiredPartial

    The values to update.

  • __namedParametersrequiredobject

    No description provided.

      Properties
    • returningrequiredminimal | representation

      By default the updated record is returned. Set this to 'minimal' if you don't need this value.

    • countrequirednull | exact | planned | estimated

      Count algorithm to use to count rows in a table.

Notes

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

Examples

Updating your data

const { data, error } = await supabase
.from('cities')
.update({ name: 'Middle Earth' })
.match({ name: 'Auckland' })

Updating JSON data

Postgres offers a number of operators for working with JSON data. Right now it is only possible to update an entire JSON document, but we are working on ideas for updating individual keys.

const { data, error } = await supabase
.from('users')
.update(`
address: {
street: 'Melrose Place',
postcode: 90210
}
`)
.eq('address->postcode', 90210)