TYPES
Provides information about supported data types. This table does not include inlined complex types; see COMPLEX_TYPES instead. This table does include arrays and sets of primitive types.
| Column Name | Data Type | Description |
|---|---|---|
TYPE_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the specific data type. |
ODBC_TYPE
|
INTEGER |
The numerical ODBC type. |
|
|
INTEGER |
The numerical ODBC subtype, used to differentiate types such as time and interval that have multiple subtypes. |
|
|
INTEGER |
The minimum number of digits supported to the right of the decimal point for the data type. |
|
|
INTEGER |
The maximum number of digits supported to the right of the decimal point for the data type. A value of 0 is used for types that do not use decimal points. |
|
|
INTEGER |
The number of characters required to display the type. See: http://msdn.microsoft.com/en-us/library/windows/desktop/ms711786%28v=VS.85%29.aspx for the details on COLUMN_SIZE for each type. |
|
|
INTEGER |
For data types that are intervals, the bitmask to determine the range of the interval from the Vertica TYPE_ID. Details are available in the Vertica SDK. |
|
|
VARCHAR |
The data type name associated with a particular data type ID. |
|
|
VARCHAR |
A list of keywords, separated by commas, corresponding to each parameter that the application may specify in parentheses when using the name that is returned in the TYPE_NAME field. The keywords in the list can be any of the following: length, precision, or scale. They appear in the order that the syntax requires them to be used. |