limit method

PostgrestTransformBuilder<T> limit(
  1. int count, {
  2. String? referencedTable,
})

Limits the result with the specified count.

final data = await supabase.from('users').select().limit(1);

If we want to limit a referenced table column, referencedTable has to beset

final data = await supabase
  .from('users')
  .select('messages(*)')
  .limit(1, referencedTable: 'messages');

Implementation

PostgrestTransformBuilder<T> limit(int count, {String? referencedTable}) {
  final key = referencedTable == null ? 'limit' : '$referencedTable.limit';

  final url = appendSearchParams(key, '$count');
  return PostgrestTransformBuilder(copyWithUrl(url));
}