REST from your database catalog
    DocumentationCheat sheetQuestionsDownloadSource
    Questions
    • How do I...?
    Start here
    • Getting started
    • What a table becomes
    • Compared with PostgREST
    Setting up
    • Tables, columns and relations
    • Security and hooks
    • Writes and procedures
    • Prefer: return=representation
    • Node, Fastify, Express
    Reading
    • select
    • /{key}
    • relation(...)
    • order
    • limit, offset
    • relation.order, .limit
    • count
    • count(), sum(), avg()...
    • "name"
    Filtering
    • eq, neq
    • gt, gte, lt, lte
    • in
    • like, ilike
    • match, imatch
    • is
    • ov, cs, cd
    • not
    • relation.column
    • or, and
    Databases
    • Supported databases
    • Adding a database
    Reference
    • Cheat sheet
    • Errors
    Filtering

    One of a list

    Keep the rows whose column takes one of the listed values.

    id=in.(1,3)name=in.(work,home)name=in.("a,b",c)

    The list sits in parentheses, separated by commas. An item that itself holds a comma goes in double quotes.

    A list holds at most 500 items by default (limits.inList), and an empty one is refused.

    Examples

    Todos 1 and 3.
    /todos?select=id,name&id=in.(1,3)

    Asking the database...

    The quoted item is one tag named "work,home", which does not exist, so only urgent matches.
    /tags?select=name&name=in.("work,home",urgent)

    Asking the database...

    See alsoEqual, not equal Turn a filter around
    PreviousGreater or less thanNext Match a pattern
    restloom - a REST API generated from your database catalog
    DocumentationDownloadSource