JavaScript: Upsert data

Perform an UPSERT on the table or view. Depending on the column(s) passed to onConflict, .upsert() allows you to perform the equivalent of .insert() if a row with the corresponding onConflict columns doesn't exist, or if it does exist, perform an alternative action depending on ignoreDuplicates.

• Primary keys must be included in values to use upsert.

Parameters

• values

  (Required)

  The values to upsert with. Pass an object to upsert a single row or an array to upsert multiple rows.

• options

  (Optional)

  Named parameters

Examples

Upsert your data

const \{ data, error \} = await supabase
  .from('countries')
  .upsert(\{ id: 1, name: 'Albania' \})
  .select()

Bulk Upsert your data

const \{ data, error \} = await supabase
  .from('countries')
  .upsert([
    \{ id: 1, name: 'Albania' \},
    \{ id: 2, name: 'Algeria' \},
  ])
  .select()

Upserting into tables with constraints

const \{ data, error \} = await supabase
  .from('users')
  .upsert(\{ id: 42, handle: 'saoirse', display_name: 'Saoirse' \}, \{ onConflict: 'handle' \})
  .select()