Fetch data
Perform a SELECT query on the table or view.
- 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 Filtersselect()
can be combined with Modifiersapikey
is a reserved keyword if you're using the Supabase Platform and should be avoided as a column name.
Parameters
columns
Optional
StringThe columns to retrieve, separated by commas. Columns can be renamed when returned with customName:columnName
final data = await supabase
.from('cities')
.select('name');