Prepare for the PgBouncer and IPv4 deprecations on 26th January 2024

Javascript Reference v2.0

Fetch data

Perform a SELECT query on the table or view.

  • By default, Supabase projects return a maximum of 1,000 rows. This setting can be changed in your project's 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 Filters
  • select() can be combined with Modifiers
  • apikey is a reserved keyword if you're using the Supabase Platform and should be avoided as a column name.
Parameters
    columns
    Optional
    Query

    The columns to retrieve, separated by commas. Columns can be renamed when returned with `customName:columnName`

    options
    Optional
    object

    Named parameters


const { data, error } = await supabase
  .from('countries')
  .select()