Flutter: 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.

Examples

Create a record

await supabase
    .from('cities')
    .insert(\{'name': 'The Shire', 'country_id': 554\});

Fetch inserted record

final List<Map<String, dynamic>> data =
        await supabase.from('cities').insert([
      \{'name': 'The Shire', 'country_id': 554\},
      \{'name': 'Rohan', 'country_id': 555\},
    ]).select();

Bulk create

await supabase.from('cities').insert([
  \{'name': 'The Shire', 'country_id': 554\},
  \{'name': 'Rohan', 'country_id': 555\},
]);