Javascript Reference v1.0

Upsert data

Performs an UPSERT into the table.

Primary keys should be included in the data payload in order for an update to work correctly.
Primary keys must be natural, not surrogate. There are however, workarounds for surrogate primary keys.
If you need to insert new data and update existing data at the same time, use Postgres triggers.

values

REQUIRED

object

The values to insert.

__namedParameters

Optional

object

returning

Optional

object

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

onConflict

REQUIRED

undefined | string

By specifying the `on_conflict` query parameter, you can make UPSERT work on a column(s) that has a UNIQUE constraint.

ignoreDuplicates

Optional

boolean

Specifies if duplicate rows should be ignored and not inserted.

count

Optional

object

Count algorithm to use to count rows in a table.


const { data, error } = await supabase
  .from('messages')
  .upsert({ id: 3, message: 'foo', username: 'supabot' })