Perform a SELECT query on the table or view.
range()
queries to paginate through your data.select()
can be combined with Filtersselect()
can be combined with Modifiersapikey
is a reserved keyword if you're using the Supabase Platform and should be avoided as a column name.final data = await supabase
.from('cities')
.select('name');
final data = await supabase
.from('countries')
.select('''
name,
cities (
name
)
''');
final data = await supabase
.from('products')
.select('''
id,
supplier:supplier_id ( name ),
purchaser:purchaser_id ( name )
''');
final data = await supabase
.from('messages')
.select('*, users!inner(*)')
.eq('users.username', 'Jane');
final data = await supabase
.from('messages')
.select('*, users!inner(*)')
.eq('users.username', 'Jane');
final res = await supabase.from('cities').select(
'name',
const FetchOptions(
count: CountOption.exact,
),
);
final count = res.count;
final data = await supabase
.from('users')
.select('''
id, name,
address->street
''')
.eq('address->postcode', 90210);
final data = await supabase
.from('users')
.select()
.csv();
final data = await supabase
.useSchema('myschema')
.from('users')
.select();