Python: Order the results

Order the query result by column.

Parameters

• column

  (Required)

  The column to order by

• desc

  (Optional)

  Whether the rows should be ordered in descending order or not.

• foreign_table

  (Optional)

  Foreign table name whose results are to be ordered.

• nullsfirst

  (Optional)

  Order by showing nulls first

Examples

With `select()`

response = (
    supabase.table("countries")
    .select("*")
    .order("name", desc=True)
    .execute()
)

On a foreign table

response = (
    supabase.table("countries")
    .select("name, cities(name)")
    .order("name", desc=True, foreign_table="cities")
    .execute()
)