Postgres: Simple object queries¶

Introduction¶

You can fetch a single node or multiple nodes of the same type using a simple object query.

Fetch list of objects¶

Example: Fetch a list of authors:

query {
  authors {
    id
    name
  }
}

Fetch an object using its primary key¶

Example: Fetch an author using their primary key:

query {
  authors_by_pk(id: 1) {
    id
    name
  }
}

Fetch value from JSON/JSONB column at particular path¶

Example: Fetch the city and phone number of an author from their JSONB address column:

query {
  authors_by_pk(id: 1) {
    id
    name
    address
    city: address(path: "$.city")
    phone: address(path: "$.phone_numbers.[0]")
  }
}

See the API reference for more details.