Kotlin: Insert data

• When calling an insert method, you have to provide a serializable value.
• By default, every time you run insert(), the client library will make a select to return the full record. This is convenient, but it can also cause problems if your policies are not configured to allow the select operation.

Parameters

• value

  (Required)

  The value(s) you want to insert. `T` can be any serializable type.

• request

  (Optional)

  Additional configuration & filtering for the request.

Examples

Create a record

val city = City(name = "The Shire", countryId = 554)
supabase.from("cities").insert(city)

Create a record and return it

val city = City(name = "The Shire", countryId = 554)
val result = supabase.from("cities").insert(city) \{ 
    select() 
\}.decodeSingle<City>()

Bulk create

val theShire = City(name = "The Shire", countryId = 554)
val rohan = City(name = "Rohan", countryId = 554)
supabase.from("cities").insert(listOf(theShire, rohan))