Supabase: get table count in rest mode

Question

There is any way to get the table count in rest mode?

I'm using query params like:

https://urt.to.supabase/rest/v1/table?select=field,another_field

I was googling it out but without success.

Answer 1

What you need to do is to add Prefer: count=exact to the request header.

Example of this using curl would be like this:

curl "https://urt.to.supabase/rest/v1/table?select=field,another_field" -I \
  -H "Prefer: count=exact"

The count value will be the number after / on the content-range header on your response. In the following example, row count is 3573458.

Content-Range: 0-24/3573458

You can read more about it on postgrest documentation here.

Note that with the Supabase.js library, you easily get the count of

const { data, error, count } = await supabase
  .from('cities')
  .select('name', { count: 'exact' })

You can read more about it on the official docs.