---
title: "Get all postgres instances in a project"
method: GET
path: "/api/projects/{projectName}/postgres"
tags: ["postgres"]
---

# Get all postgres instances in a project

`GET /api/projects/{projectName}/postgres`

## Request

- Base URL: `https://api.hostim.dev`
- URL: `https://api.hostim.dev/api/projects/{projectName}/postgres`
- Auth: HTTP bearer

Get all postgres instances in a project

## Path parameters

- `projectName` string, required

## Response `200`

OK

- Postgres[]
  - `name` string, required: The PostgreSQL name
  - `plan` string, required: The plan of the PostgreSQL instance
  - `cost` number: The cost of the PostgreSQL instance per month
  - `type` string: The type of the PostgreSQL instance, either shared or dedicated
  - `ram` number: The amount of RAM in GB
  - `cores` number: The number of CPU cores
  - `storageMB` number: The amount of storage in MB
  - `extensions` string[]: Extensions requested for this database. Only names returned by /api/postgres/extensions are accepted. Removing a name does not uninstall the extension.

## Other responses

- `401`: User is not authorized
- `404`: Project not found
- `500`: Internal server error

---

[API](https://skmtc.dev/hostim/apis/hostim-api.md) · [All operations](https://skmtc.dev/hostim/apis/hostim-api/llms.txt) · [OpenAPI document](https://skmtc.dev/hostim/apis/hostim-api/revisions/37c35e1026a9?raw)