Prepare for the PgBouncer and IPv4 deprecations on 26th January 2024

Home

Don't match the filter

Match only rows which doesn't satisfy the filter.

not() expects you to use the raw PostgREST syntax for the filter values.

1.not('id', 'in', '(5,6,7)')  // Use `()` for `in` filter
2.not('arraycol', 'cs', '{"a","b"}')  // Use `cs` for `contains()`, `{}` for array values
Parameters
    column
    REQUIRED
    string

    The column to filter on

    operator
    REQUIRED
    string

    The operator to be negated to filter with, following PostgREST syntax

    value
    REQUIRED
    any

    The value to filter with, following PostgREST syntax


const { data, error } = await supabase
  .from('countries')
  .select()
  .not('name', 'is', null)