JavaScript: Return data after inserting

Perform a SELECT on the query result.

By default, .insert(), .update(), .upsert(), and .delete() do not return modified rows. By calling this method, modified rows are returned in data.

Parameters

• columns

  (Optional)

  The columns to retrieve, separated by commas

Examples

With `upsert()`

const { data, error } = await supabase
  .from('characters')
  .upsert({ id: 1, name: 'Han Solo' })
  .select()