Creating an Extension

Function

This API is used to create an extension for a specified database.

Before calling an API, you need to understand the API in Authentication.

Constraints

This operation cannot be performed when the DB instance is in any of the following statuses: creating, changing instance class, changing port, frozen, or abnormal.

URI

URI format
POST /v3/{project_id}/instances/{instance_id}/extensions

Parameter description

**Table 1** Parameters
Parameter	Mandatory	Description
project_id	Yes	Project ID of a tenant in a region. For details about how to obtain the project ID, see Obtaining a Project ID.
instance_id	Yes	Instance ID.

Request

**Table 2** Parameters
Parameter	Mandatory	Type	Description
database_name	Yes	String	Database name.
extension_name	Yes	String	Extension name.

Example Request

Create the extension pg_stat_statements for database db1.

POST https://{endpoint}/v3/0483b6b16e954cb88930a360d2c4e663/instances/f569f1358436479dbcba8603c32cc4aein03/extensions

{
  "database_name" : "db1",  
  "extension_name" : "pg_stat_statements"  
}