/show/types

URL: http://<db.host>:<db.port>/show/types

Retrieves information for the specified data type ID or type label. For all data types that match the input criteria, the database returns the type ID, the type schema, the label (if available), and the type's column properties.

Input Parameter Description

Name

Type

Description

type_id

string

Type Id returned in response to a call to /create/type.

label

string

Option string that was supplied by user in a call to /create/type.

options

map of string to strings

Optional parameters. The default value is an empty map ( {} ).

Supported Parameters (keys)

Parameter Description

no_join_types

When set to 'true', no join types will be included. The default value is false. The supported values are:

true
false

Output Parameter Description

The GPUdb server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query. Here is a description of the various fields of the wrapper:

Name

Type

Description

status

String

'OK' or 'ERROR'

message

String

Empty if success or an error message

data_type

String

'show_types_response' or 'none' in case of an error

data

String

Empty string

data_str

JSON or String

This embedded JSON represents the result of the /show/types endpoint:

Name	Type	Description
type_ids	array of strings
type_schemas	array of strings
labels	array of strings
properties	array of maps of string to arrays of strings
info	map of string to strings	Additional information.

Empty string in case of an error.