Updated on 2024-08-28 GMT+08:00

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"  
}

Response

Status Code

Error Code

For details, see Error Codes.