Managed Service for PostgreSQL API, REST: Database.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 |
Response
HTTP Code: 200 - OK
{
"name": "string",
"clusterId": "string",
"owner": "string",
"lcCollate": "string",
"lcCtype": "string",
"extensions": [
{
"name": "string",
"version": "string"
}
],
"templateDb": "string",
"deletionProtection": true
}
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. |
extensions[]. version |
string Version of the extension. |
templateDb | string Name of the database template. |
deletionProtection | boolean (boolean) Deletion Protection inhibits deletion of the database Default value: |