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.try await supabase.database
.from("countries")
.delete()
.eq("id", value: 1)
.execute()