通过count限制查询结果。

  create table
countries (id int8 primary key, name text);

insert into
countries (id, name)
values
(1, 'Afghanistan'),
(2, 'Albania'),
(3, 'Algeria');
  
  const { data, error } = await supabase
 .from('countries')
 .select('name')
 .limit(1)
  
  {
"data": [
  {
    "name": "Afghanistan"
  }
],
"status": 200,
"statusText": "OK"
}

案例2 （在外键表中） 

  create table
countries (id int8 primary key, name text);
create table
cities (
  id int8 primary key,
  country_id int8 not null references countries,
  name text
);

insert into
countries (id, name)
values
(1, 'United States');
insert into
cities (id, country_id, name)
values
(1, 1, 'Atlanta'),
(2, 1, 'New York City');
  
  const { data, error } = await supabase
.from('countries')
.select(`
  name,
  cities (
    name
  )
`)
.limit(1, { foreignTable: 'cities' })
  
  {
"data": [
  {
    "name": "United States",
    "cities": [
      {
        "name": "Atlanta"
      }
    ]
  }
],
"status": 200,
"statusText": "OK"
}