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
|
Field |
Description |
|
clusterId |
string Required field. ID of the PostgreSQL cluster that the database belongs to. |
|
databaseName |
string Required field. Name of the PostgreSQL Database resource to return. |
Response
HTTP Code: 200 - OK
{
"name": "string",
"clusterId": "string",
"owner": "string",
"lcCollate": "string",
"lcCtype": "string",
"extensions": [
{
"name": "string",
"version": "string"
}
],
"templateDb": "string",
"deletionProtection": "boolean"
}
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. |
|
lcCtype |
string POSIX locale for character classification. |
|
extensions[] |
PostgreSQL extensions enabled for the database. |
|
templateDb |
string Name of the database template. |
|
deletionProtection |
boolean Deletion Protection inhibits deletion of the database Default value: |
Extension
|
Field |
Description |
|
name |
string Name of the extension, e.g. |
|
version |
string Version of the extension. The setting is deprecated and has no effect. |