Skip to main content
POST
/
postgresgateway
/
tables
/
{username}
/
byids
Python SDK
res = client.postgres_gateway.tables.retrieve("myUserName", 'myCustom')

res = client.postgres_gateway.tables.retrieve("myUserName", ["myCustom", "myCustom2"])
{
  "items": [
    {
      "columns": {},
      "type": "raw_rows",
      "tablename": "<string>",
      "options": {
        "space": "<string>",
        "externalId": "<string>",
        "version": "<string>"
      }
    }
  ]
}

Documentation Index

Fetch the complete documentation index at: https://docs.cognite.com/llms.txt

Use this file to discover all available pages before exploring further.

Authorizations

​
Authorization
string
header
required

Access token issued by the CDF project's configured identity provider. Access token must be an OpenID Connect token, and the project must be configured to accept OpenID Connect tokens. Use a header key of 'Authorization' with a value of 'Bearer $accesstoken'. The token can be obtained through any flow supported by the identity provider.

Path Parameters

​
username
string
required

The name of the username (a.k.a. database) to be managed from the API Username to authenticate the user on the DB.

Body

application/json
​
items
Items · object[]
required
Required array length: 1 - 10 elements
​
ignoreUnknownIds
boolean

Ignore table names not found

Response

List postgres tables by table names

​
items
(Custom) Table · object[]
required
Last modified on May 13, 2026