delete()
should always be combined with filters to target the item(s) you wish to delete.delete()
with filters and you have RLS enabled, only rows visible through SELECT
policies are deleted. Note that by default no rows are visible, so you need at least one SELECT
/ALL
policy that makes the rows visible.delete().in_()
, specify an array of values to target multiple rows with a single query. This is particularly useful for batch deleting entries that share common criteria, such as deleting users by their IDs. Ensure that the array you provide accurately represents all records you intend to delete to avoid unintended data removal.The property to use to get the count of rows returned.
Either 'minimal' or 'representation'. Defaults to 'representation'.
response = supabase.table('countries').delete().eq('id', 1).execute()
response = supabase.table("countries").delete().in_("id", [1, 2, 3]).execute()