JavaScript: Insert data

Perform an INSERT into the table or view.

Parameters

• values

  (Required)

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

• options

  (Optional)

  Named parameters

Examples

Create a record

const \{ error \} = await supabase
  .from('countries')
  .insert(\{ id: 1, name: 'Mordor' \})

Create a record and return it

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

Bulk create

const \{ error \} = await supabase
  .from('countries')
  .insert([
    \{ id: 1, name: 'Mordor' \},
    \{ id: 1, name: 'The Shire' \},
  ])