Databases

PostgreSQL extensions you can enable (pgvector, pg_trgm, uuid-ossp, citext, hstore, pgcrypto, …) and which are installed

get/databases/{databaseId}/extensions

Request

  • Base URL: https://hostingsurge.com/api/v1
  • URL: https://hostingsurge.com/api/v1/databases/{databaseId}/extensions
  • Auth: one of:
    • HTTP bearer
    • API key in cookie __Host-hs_session

Path parameters

databaseIdstring uuid required

Query parameters

refresh'0' | '1' | 'true' | 'false'

true: read the live list from the database

Response

Extensions

databaseIdstring uuid required
supportedboolean required

extensions exist for PostgreSQL only

imagestring nullable required

database image, e.g. pgvector/pgvector:pg17

pgvectorboolean required

the image ships pgvector (the "vector" extension)

checkedAtstring nullable required

when the list was last read from the database; null = never (the list shows the allow-list only)

notestring nullable required

e.g. how to switch an older database to the pgvector image

Changes

No recorded changes to this operation across all 1 revision of this API.