Drop an extension
Runs DROP EXTENSION on the live leader, in the database of the extension, and removes the extension and its stored version from the list of the service. confirm must be the name of the extension. Without cascade, an extension with dependents gets 409 with the dependents. With cascade, the drop also drops them (DROP EXTENSION … CASCADE): their data is lost. A required extension gets 400. When the extension has a preload library, deploy the service to remove it from shared_preload_libraries.
/api/v1/database-services/{id}/extensions/{name}/droptse_sessionAPI key · cookierequiredidstringrequirednamestringrequiredThe catalog name of the extension, for example pgvector.
application/jsoncascadebooleanAlso drop the objects that depend on the extension (DROP EXTENSION ... CASCADE).
confirmstringrequiredThe catalog name of the extension, again.
OK
also_droppedstring[]requiredThe catalog names of the extensions that CASCADE dropped because they require this one. The console removes them from the list too.
cascadebooleanrequireddatabasestringrequireddependentsExtensionDependent[]requiredThe objects that CASCADE dropped.
Show propertiesHide properties
ExtensionDependentestimated_rowsinteger<int64>The estimated rows of the table (pg_class.reltuples). Not set when PostgreSQL has no estimate.
namestringrequiredThe name of the object (pg_identify_object identity). For a cron job: its name and schedule.
tablestringThe table of a column.
typestringrequiredThe type of the object (pg_identify_object), for example table column, index, view, function, or cron job.
deploy_neededbooleanrequiredThe extension has a library in shared_preload_libraries. The next deploy removes the library. A restart then unloads it.
droppedbooleanrequiredFalse when the extension did not exist in the database. The console then only removes it from the list.
extensionstringrequiredmoreinteger<int64>requiredError
codestringStable code of the refusal, when the route has codes
detailsstring[]Additional detail, e.g. per-field validation failures
errorstringrequiredHuman-readable error message