Modify data: update()
Performs an UPDATE on the table.
- JavaScript
const { data, error } = await supabase
.from('cities')
.update({ name: 'Middle Earth' })
.match({ name: 'Auckland' })
Parameters
valuesrequired
Partial
The values to update.
__namedParametersrequired
object
No description provided.
returningrequired
minimal
|representation
By default the updated record is returned. Set this to 'minimal' if you don't need this value.
countrequired
null
|exact
|planned
|estimated
Count algorithm to use to count rows in a table.
Properties
Notes
update()
should always be combined with Filters to target the item(s) you wish to update.
Examples
Updating your data
- JavaScript
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.
- JavaScript
const { data, error } = await supabase
.from('users')
.update(`
address: {
street: 'Melrose Place',
postcode: 90210
}
`)
.eq('address->postcode', 90210)