List all Databases

To retrieve a list of all databases in your PostgreSQL cluster, send a GET request to the databases endpoint. Use the limit and offset parameters to control pagination.

Note: The sample UUID in all following request examples is 498ae72f-411f-11eb-9d07-046c59cc737e.

Endpoint

Use the following endpoint to get a list of all databases in your PostgreSQL cluster:

https://api.ionos.com/databases/postgresql/clusters/{clusterId}/databases

Request

curl --request GET \
    --user "[email protected]:Mb2.r5oHf-0t" \
    https://api.ionos.com/databases/postgresql/clusters/498ae72f-411f-11eb-9d07-046c59cc737e/databases

Response

{
  "id": "68b29b09-20e3-5fbc-94bb-b193a2ef0d28",
  "items": [
    {
      "id": "13852d13-dd87-5973-ae2c-12ecc918ee0f",
      "properties": {
        "databasename": "postgres",
        "databaseowner": "postgres"
      },
      "type": "database"
    },
    {
      "id": "d3d34784-1d4c-505f-a4ec-e8f593098ea6",
      "properties": {
        "databasename": "template0",
        "databaseowner": "postgres"
      },
      "type": "database"
    },
    {
      "id": "44e6b542-3f75-5882-8a99-53ee43ac1d97",
      "properties": {
        "databasename": "template1",
        "databaseowner": "postgres"
      },
      "type": "database"
    }
  ],
  "limit": 100,
  "offset": 0,
  "type": "collection"
}