Fetch data
Performs vertical filtering with SELECT.
- By default, Supabase projects will return a maximum of 1,000 rows. This setting can be changed in Project API Settings. It's recommended that you keep it low to limit the payload size of accidental or malicious requests. You can use
range()
queries to paginate through your data. select()
can be combined with Modifiersselect()
can be combined with Filters- If using the Supabase hosted platform
apikey
is technically a reserved keyword, since the API gateway will pluck it out for authentication. It should be avoided as a column name.
Parameters
columns
Optional
stringThe columns to retrieve, separated by commas.
__namedParameters
Optional
objecthead
Optional
booleanWhen set to true, select will void data.
count
Optional
objectCount algorithm to use to count rows in a table.
const { data, error } = await supabase
.from('cities')
.select()