Kotlin: Insert data

Perform an INSERT into the table or view.

• When calling an insert method, you have to provide a serializable value.
• By default, insert will not return the inserted data. If you want to return the inserted data, you can use the select() method inside the request.

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))