Python: Limit the number of rows returned

Parameters

• size

  (Required)

  The maximum number of rows to return

• foreign_table

  (Optional)

  Set this to limit rows of foreign tables instead of the parent table.

Examples

With `select()`

response = supabase.table("countries").select("name").limit(1).execute()

On a foreign table

response = (
    supabase.table("countries")
    .select("name, cities(name)")
    .limit(1, foreign_table="cities")
    .execute()
)