List the extensions of a managed PostgreSQL database

GET

/api/databases/managed/{id}/extensions

curl --request GET \
  --url https://opfield.example.com/api/databases/managed/550e8400-e29b-41d4-a716-446655440000/extensions \
  --header 'Authorization: Bearer <token>'

• Your Opfield instance

The curated extensions Opfield offers, with their state on the database: status enabled, update_available, available, needs_bundle (a download of bundleSizeBytes into the database volume), needs_image_update (the database runs the official image: update with imageUpdate: true) or unavailable (not in this version); availableVersion, installedVersion, category, description, preloadLibraries and whether enabling or disabling restarts the database (restartToEnable, restartToDisable). Also imageUpdateAvailable, the volume space, the change in progress (pending) and the last failed one (lastError). daemonUpdateRequired true means the node daemon predates extensions (no status is reported). Needs databases:view.

Authorizations

• bearerAuth

Parameters

Path Parameters

id

required

string

>= 1 characters

Example

550e8400-e29b-41d4-a716-446655440000

Responses

200

Successful response

Media typeapplication/json

object

data

required

Resource object. Exact fields depend on the endpoint.

object

id

string

name

string

key

additional properties

Example

{
  "data": [
    {
      "id": "550e8400-e29b-41d4-a716-446655440000",
      "name": "Production Postgres",
      "type": "postgres",
      "healthStatus": "online"
    }
  ]
}

400

Bad request

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "VALIDATION_ERROR",
  "message": "Request validation failed",
  "details": [
    {
      "path": [
        "name"
      ],
      "message": "Required"
    }
  ]
}

401

Authentication required

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "UNAUTHORIZED",
  "message": "Authentication required"
}

403

Forbidden

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "FORBIDDEN",
  "message": "Insufficient permissions"
}

404

Not found

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "NOT_FOUND",
  "message": "Resource not found"
}

409

Conflict

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "CONFLICT",
  "message": "Resource already exists"
}

422

Unprocessable entity

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "UNPROCESSABLE_ENTITY",
  "message": "Request could not be processed"
}

500

Internal server error

Media typeapplication/json

object

code

required

Error code

string

message

required

Human-readable error message

string

details

Additional error details

Example

{
  "code": "INTERNAL_ERROR",
  "message": "Internal server error"
}