JavaScript: Upsert data

Examples

Upsert your data

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

Bulk Upsert your data

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

Upserting into tables with constraints

const { data, error } = await supabase
  .from('users')
  .upsert({ username: 'supabot' }, { onConflict: 'username' })

Return the exact number of rows

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