Insert data
Performs an INSERT into the table.
- By default, every time you run
insert()
, the client library will make aselect
to return the full record. This is convenient, but it can also cause problems if your Policies are not configured to allow theselect
operation. If you are using Row Level Security and you are encountering problems, try setting thereturning
param tominimal
.
Parameters
values
REQUIRED
objectoptions
Optional
object
const { data, error } = await supabase
.from('cities')
.insert([
{ name: 'The Shire', country_id: 554 }
])