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("planets")
    .select("name")
    .limit(1)
    .execute()
)

On a foreign table

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