Method get

Returns the specified PostgreSQL Database resource.

To get the list of available PostgreSQL Database resources, make a list request.

HTTP request

GET https://mdb.api.cloud.yandex.net/managed-postgresql/v1/clusters/{clusterId}/databases/{databaseName}

Path parameters

Parameter Description
clusterId Required. ID of the PostgreSQL cluster that the database belongs to. To get the cluster ID use a list request. The maximum string length in characters is 50.
databaseName Required. Name of the PostgreSQL Database resource to return. To get the name of the database use a list request. The maximum string length in characters is 63. Value must match the regular expression [a-zA-Z0-9_-]*.

Response

HTTP Code: 200 - OK

{
  "name": "string",
  "clusterId": "string",
  "owner": "string",
  "lcCollate": "string",
  "lcCtype": "string",
  "extensions": [
    {
      "name": "string",
      "version": "string"
    }
  ]
}

A PostgreSQL Database resource. For more information, see the Developer's Guide.

Field Description
name string

Name of the database.

clusterId string

ID of the PostgreSQL cluster that the database belongs to.

owner string

Name of the user assigned as the owner of the database.

lcCollate string

POSIX locale for string sorting order. Can only be set at creation time.

lcCtype string

POSIX locale for character classification. Can only be set at creation time.

extensions[] object

PostgreSQL extensions enabled for the database.

extensions[].
name
string

Name of the extension, e.g. pg_trgm or pg_btree. Extensions supported by MDB are listed in the Developer's Guide.

extensions[].
version
string

Version of the extension.