How to get "COUNT(*)" in Supabase

Question

I want to retrieve row count in Supabase.

I am guessing it would be something like this:

const { data, error } = await supabase
  .from('cities')
  .select('name', 'COUNT(*)')

Is this possible with Supabase?

Answer 1

As a workaround, you could write a standard Postgres stored procedure or function that returns the count then call that via the SB client.

https://supabase.io/docs/client/rpc