Python and Vertica data types
The Vertica Python SDK converts native Vertica data types into the appropriate Python data types.
The Vertica Python SDK converts native Vertica data types into the appropriate Python data types. The following table describes some of the data type conversions. Consult the Python SDK for a complete list, as well as lists of helper functions to convert and manipulate these data types.
For information about SDK support for complex data types, see Complex Types as Arguments and Return Values.
| Vertica Data Type | Python Data Type |
|---|---|
| INTEGER | int |
| FLOAT | float |
| NUMERIC | decimal.Decimal |
| DATE | datetime.date |
| CHAR, VARCHAR, LONG VARCHAR | string (UTF-8 encoded) |
| BINARY, VARBINARY, LONG VARBINARY | binary |
| TIMESTAMP | datetime.datetime |
| TIME | datetime.time |
| ARRAY |
list Note: Nested ARRAY types are also converted into lists. |
| ROW |
collections.OrderedDict Note: Nested ROW types are also converted into collections.OrderedDicts. |