Skip to main content
Version: v1-dev

Modify data: update()

Performs an UPDATE on the table.

final data = await supabase
.from('cities')
.update({ 'name': 'Middle Earth' })
.match({ 'name': 'Auckland' });

Notes

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

Examples

Updating your data

final data = 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.

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