Performs an UPSERT into the table.
The values to insert.
No description provided.
By default the new record is returned. Set this to 'minimal' if you don't need this value.
By specifying the
on_conflictquery parameter, you can make UPSERT work on a column(s) that has a UNIQUE constraint.
Specifies if duplicate rows should be ignored and not inserted.
Count algorithm to use to count rows in a table.
- Primary keys should to be included in the data payload in order for an update to work correctly.
- Primary keys must be natural, not surrogate. There are however, workarounds for surrogate primary keys.
Upsert your data
Upserting into tables with constraints
Running the following will cause supabase to upsert data into the
If the username 'supabot' already exists, the
onConflict argument tells supabase to overwrite that row
based on the column passed into
Return the exact number of rows