Retrieve a list of tables by their tables names

Retreive a list of postgres tables for a user by their table names, optionally ignoring unknown table names

Securityoidc-token or oauth2-client-credentials or oauth2-open-industrial-data or oauth2-auth-code
Request
path Parameters
username
required
string (Username)

The name of the username (a.k.a. database) to be managed from the API

Request Body schema: application/json
required
Array of objects (Items) [ 1 .. 10 ] items
ignoreUnknownIds
boolean (IgnoreUnknown)

Ignore table names not found

Responses
200

List postgres tables by table names

400

Response of a failed request

422

Validation Error

post/postgresgateway/tables/{username}/byids
Request samples
application/json
{
  • "items": [
    • {
      }
    ],
  • "ignoreUnknownIds": true
}
Response samples
application/json
{
  • "items": [
    • {
      }
    ]
}
➔ Next to Data workflows / Workflows