Get started
Log in
Yandex Managed Service for PostgreSQL

Method list

Retrieves the list of PostgreSQL User resources in the specified cluster.

HTTP request

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

Path parameters

Parameter Description
clusterId Required. Required. ID of the cluster to list PostgreSQL users in. To get the cluster ID, use a list request. The maximum string length in characters is 50.

Query parameters

Parameter Description
pageSize The maximum value is 1000.
pageToken Page token. To get the next page of results, set pageToken to the nextPageToken returned by a previous list request. The maximum string length in characters is 100.

Response

HTTP Code: 200 - OK

 {
  "users": [
    {
      "name": "string",
      "clusterId": "string",
      "permissions": [
        {
          "databaseName": "string"
        }
      ],
      "connLimit": "string"
    }
  ],
  "nextPageToken": "string"
}
Field Description
users[] object

A PostgreSQL User resource. For more information, see the Developer's Guide.
users[].
name		 string

Name of the PostgreSQL user.
users[].
clusterId		 string

ID of the PostgreSQL cluster the user belongs to.
users[].
permissions[]		 object

Set of permissions granted to the user.
users[].
permissions[].
databaseName		 string

Name of the database that the permission grants access to.
users[].
connLimit		 string (int64)

Number of database connections available to the user.
nextPageToken string

This token allows you to get the next page of results for list requests. If the number of results is larger than pageSize, use the nextPageToken as the value for the pageToken parameter in the next list request. Each subsequent list request will have its own nextPageToken to continue paging through the results.