Python and Vertica Data Types

The Vertica Python SDK converts native Vertica data types into the appropriate Python data types, as follows:

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

Some Vertica Analytic Database data types are not supported in Python.