Python: Fetch data

• 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)

  The columns to retrieve, defaults to `*`.

• count

  (Optional)

  The property to use to get the count of rows returned.

Examples

Getting your data

response = (
    supabase.table("planets")
    .select("*")
    .execute()
)

Selecting specific columns

response = (
    supabase.table("planets")
    .select("name")
    .execute()
)

Query referenced tables

response = (
    supabase.table("orchestral_sections")
    .select("name, instruments(name)")
    .execute()
)

Query referenced tables through a join table

response = (
    supabase.table("users")
    .select("name, teams(name)")
    .execute()
)

Query the same referenced table multiple times

response = (
    supabase.table("messages")
    .select("content,from:sender_id(name),to:receiver_id(name)")
    .execute()
)

Filtering through referenced tables

response = (
    supabase.table("orchestral_sections")
    .select("name, instruments(*)")
    .eq("instruments.name", "guqin")
    .execute()
)

Querying referenced table with count

response = (
    supabase.table("orchestral_sections")
    .select("*, instruments(count)")
    .execute()
)

Querying with count option

response = (
    supabase.table("planets")
    .select("*", count="exact")
    .execute()
)

Querying JSON data

response = (
    supabase.table("users")
    .select("id, name, address->city")
    .execute()
)

Querying referenced table with inner join

response = (
    supabase.table("instruments")
    .select("name, orchestral_sections!inner(name)")
    .eq("orchestral_sections.name", "woodwinds")
    .execute()
)

Switching schemas per query

response = (
    supabase.schema("myschema")
    .table("mytable")
    .select("*")
    .execute()
)