---
title: "List PostgreSQL extensions that can be loaded with CREATE EXTENSION in this service"
method: GET
path: "/project/{project}/service/{service_name}/pg/available-extensions"
tags: ["Service:_PostgreSQL"]
---

# List PostgreSQL extensions that can be loaded with CREATE EXTENSION in this service

`GET /project/{project}/service/{service_name}/pg/available-extensions`

## Path parameters

- `project` string, required
- `service_name` string, required

## Response `200`

Response

- PGServiceAvailableExtensionsResponse — PGServiceAvailableExtensionsResponse
  - `errors` object[] — List of errors occurred during request processing
    - `message` string, required — Printable error message
    - `more_info` string — URL to the documentation of the error
    - `status` integer, required — HTTP error status code
  - `extensions` object[], required — Extensions available for loading with CREATE EXTENSION in this service
    - `default_version` string — Default version
    - `name` string, required — Extension name
    - `versions` string[] — Extension versions available
  - `message` string — Printable result of the request

---

[API](https://skmtc.net/aiven/apis/aiven-api-documentation.md) · [All operations](https://skmtc.net/aiven/apis/aiven-api-documentation/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aiven/aiven-api-documentation/versions/ecaeabf1da31/schema)