Fetch data: select()

Perform a SELECT query on a table or view.

Parameters

columnsstring

The columns to retrieve, separated by commas. Rename a column with alias:column.

options.count'exact' | 'planned'

Count algorithm to use to count rows in the table or view.

options.headboolean

When true, data is null and only the count is returned.

By default, Basalt returns at most 1,000 rows. Change the limit in your project's API settings, or page through results with range().

Is this helpful?

const { data, error } = await basalt
  .from('characters')
  .select()

const { data, error } = await basalt
  .from('characters')
  .select('name, house')

{
  "data": [
    { "id": 1, "name": "Ada" },
    { "id": 2, "name": "Grace" }
  ],
  "status": 200
}

Is this helpful?

AI tools