RArafftechnologies
Managed Databases

List extensions

Changed on

Every PostgreSQL extension the database can turn on, with whether it is on. curated marks the most used ones (vector, pg_trgm, pg_stat_statements, hstore, uuid-ossp, citext, ltree, pgcrypto, unaccent). Extensions that reach the server's files or run untrusted languages are left out. Other engines return an empty list. The database must be running.

get/api/v1/databases/{database_id}/extensions

Request

  • Base URL
    https://api.rafftechnologies.com
  • URL
    https://api.rafftechnologies.com/api/v1/databases/{database_id}/extensions
  • Auth
    API key in header X-API-Key

Path parameters

database_idstring required

Database ID (UUID) or short id (the database_id field, e.g. a1b2c3d4)

Response

Extension catalog with installed state

successboolean

Example response

{
  "extensions": [
    {
      "name": "pgvector"
    }
  ]
}

Changes