MAmachines
Postgres Clusters

Enable Extension

Changed on

Enable a Postgres extension within a specific database. PostGIS extensions require a PostGIS-enabled cluster.

post/v1/postgres/{postgres_cluster_id}/databases/{database_name}/extensions

Request

  • Base URL
    https://api.machines.dev
  • URL
    https://api.machines.dev/v1/postgres/{postgres_cluster_id}/databases/{database_name}/extensions
  • Auth
    HTTP bearer

Path parameters

postgres_cluster_idstring required

Managed Postgres Cluster ID

database_namestring required

Database Name

Request body

create_schemaboolean

Create the schema first if it does not exist.

namestring required

Extension to enable.

schemastring

Schema to install the extension into. Defaults to the database's default schema.

Example request

{
  "name": "citext"
}

Response

No Content

Changes

  • ab2c6417040dRevision changes
    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

  • 4a82f51548c8Revision changes
    • info

      the endpoint scheme security FlyBearerAuth was removed from the API