single()

Retrieves only one row from the result. Result must be one row (e.g. using limit), otherwise this will result in an error.

JavaScript

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

.limit(1)

.single()

Examples

With select()

JavaScript

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

.limit(1)

.single()