> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sabaothcloud.com/llms.txt
> Use this file to discover all available pages before exploring further.

# sabaoth postgres list

> List PostgreSQL services in an organization

Lists the PostgreSQL services in the effective organization. Returns one page unless you pass `--all`.

```bash theme={null}
sabaoth postgres list [--page <n>] [--page-size <n>] [--all] [--org <org-id>] [--json]
```

## Flags

**--page** `integer`

Page number to fetch, starting from `1`. Defaults to the first page.

**--page-size** `integer`

Number of services per page, `1` or more. If left out, the server's default is used.

**--all** `boolean` (default: false)

Fetch every page instead of just one.

**--org** `string`

Organization to act in, instead of the selected one. See [Organizations and context](https://docs.sabaothcloud.com/cli/organizations.md).

**--json** `boolean` (default: false)

Print the result as JSON on stdout.

## Examples

```bash theme={null}
sabaoth postgres list
sabaoth postgres list --page 2 --page-size 50
sabaoth postgres list --all --json
sabaoth postgres list --org org_abc
```

## Output

```text theme={null}
$ sabaoth postgres list
ID       NAME       STATUS        VERSION  CPU   MEMORY  STORAGE  REPLICAS
clu_abc  orders-db  ready         16       500m  1024Mi  10Gi     1
clu_def  analytics  provisioning  17       2000m 4096Mi  40Gi     1

Showing 2 of 2.
```

CPU is in millicores (`1000m` is one vCPU), memory in MiB and storage in GiB.

With `--json`:

```json theme={null}
{
  "items": [
    {
      "id": "clu_abc",
      "name": "orders-db",
      "status": "ready",
      "postgres_version": "16",
      "cpu_millicores": 500,
      "memory_mb": 1024,
      "storage_gb": 10,
      "replicas": 1,
      "created_at": "2026-01-01T00:00:00Z"
    }
  ],
  "page": 1,
  "page_size": 20,
  "total": 1
}
```

| Field | Description |
| - | - |
| `items` | The services on this page (or every service, with `--all`). |
| `page`, `page_size` | The page returned and its size. |
| `total` | Total services in the organization. |

Connection details, networking and backup settings aren't included in the list. Use [`sabaoth postgres get`](https://docs.sabaothcloud.com/cli/commands/postgres-get) for those.

## Behavior

* **One page by default.** `Showing 20 of 45.` means there are more pages. Use `--page` or `--all` to see them.
* **`--all` never returns a partial list as if it were complete.** If an error happens part-way through, the whole command fails. If it stops at the CLI's internal page limit, you get a warning that the list may be incomplete (in `--json` mode, inside a `warnings` array).

## Errors

| Code | Exit | Meaning |
| - | - | - |
| `INVALID_PAGE` | 2 | `--page` must be a whole number of 1 or more. |
| `INVALID_PAGE_SIZE` | 2 | `--page-size` must be a whole number of 1 or more. |

You may also see authentication, organization and network errors. See [Error codes](https://docs.sabaothcloud.com/cli/errors.md).

## Related

* [`sabaoth postgres get`](https://docs.sabaothcloud.com/cli/commands/postgres-get)
* [`sabaoth postgres create`](https://docs.sabaothcloud.com/cli/commands/postgres-create)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.