import GraphiQLIDE from '@site/src/components/GraphiQLIDE';

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:

<GraphiQLIDE query={query { authors { id name } }} response={{ "data": { "authors": [ { "id": 1, "name": "Justin" }, { "id": 2, "name": "Beltran" }, { "id": 3, "name": "Sidney" }, { "id": 4, "name": "Anjela" } ] } }} />

Fetch an object using its primary key

Example: Fetch an author using their primary key:

<GraphiQLIDE query={query { authors_by_pk(id: 1) { id name } }} response={{ "data": { "authors_by_pk": { "id": 1, "name": "Justin" } } }} />

Fetch value from JSON/JSONB column at particular path

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

<GraphiQLIDE query={query { authors_by_pk(id: 1) { id name address city: address(path: "$.city") phone: address(path: "$.phone_numbers.[0]") } }} response={{ "data": { "authors_by_pk": { "id": 1, "name": "Justin", "address": { "city": "Bengaluru", "phone_numbers": [9090909090, 8080808080] }, "city": "Bengaluru", "phone": 9090909090 } } }} />

See the API reference for more details.