Match a string

Finds all rows whose text or tsvector value on the stated column matches the tsquery in query.

Parameters

column

REQUIRED

object

The column to filter on.

query

REQUIRED

string

The Postgres tsquery string to filter with.

__namedParameters

Optional

object

type

Optional

object

The type of tsquery conversion to use on `query`.

config

REQUIRED

undefined | string

The text search configuration to use.


const { data, error } = await supabase
  .from('quotes')
  .select('catchphrase')
  .textSearch('catchphrase', `'fat' & 'cat'`, {
    config: 'english'
  })