supabase-rb-rb
Database

Column equals a value

Match rows where a column equals a value.

Filter rows where column = value. Chains onto any verb builder (select, update, delete, upsert).

Signature

builder.eq(column, value)

Parameters

NameTypeRequiredDescription
columnString / SymbolRequiredColumn name. PostgREST dotted paths (e.g. "author.name") work for embedded resources.
valueAnyRequiredValue to compare against. Numbers, strings, booleans, dates — passed verbatim to the PostgREST query string.

Returns

Returns
self (FilterRequestBuilder)

The same builder, so you can keep chaining filters or modifiers before .execute.

Example — match a single row by id

response = supabase
  .from("countries")
  .select("id, name")
  .eq("id", 1)
  .execute

response.data  # => [{ "id" => 1, "name" => "Algeria" }]

Example — combine with other filters

supabase
  .from("orders")
  .select("id, total")
  .eq("status", "paid")
  .gte("total", 100)
  .execute

On this page