Introduction
Initializing
Upgrade guide
Database
Fetch data
Insert data
Update data
Upsert data
Delete data
Call a Postgres function
Using filters
Column is equal to a value
Column is not equal to a value
Column is greater than a value
Column is greater than or equal to a value
Column is less than a value
Column is less than or equal to a value
Column matches a pattern
Column matches a case-insensitive pattern
Column is a value
Column is in an array
Column contains every element in a value
Contained by value
Greater than a range
Greater than or equal to a range
Less than or equal to a range
Mutually exclusive to a range
With a common element
Match a string
Match an associated value
Don't match the filter
Match at least one filter
Match the filter
Using modifiers
Order the results
Limit the number of rows returned
Limit the query to a range
Retrieve one row of data
Retrieve zero or one row of data
Auth
Create a new user
Listen to auth events
Sign in a user
Sign out a user
Send a password reset request
Update a user
Update the access token
Retrieve a user
Retrieve a session
Retrieve a user
Edge Functions
Invokes a Supabase Edge Function.
Realtime
Subscribe to channel
Remove a subscription
Remove all subscriptions
Retrieve subscriptions
Storage
Create a bucket
Retrieve a bucket
List all buckets
Update a bucket
Delete a bucket
Empty a bucket
Upload a file
Download a file
List all files in a bucket
Replace an existing file
Move an existing file
Copy an existing file
Delete files in a bucket
Create a signed URL
Create signed URLs
Retrieve public URL
JavaScript: Limit the query to a range
Examples
With `select()`
const \{ data, error \} = await supabase .from('cities') .select('name, country_id') .range(0,3)