Python and Vertica data types
The Vertica Python SDK converts native Vertica data types into the appropriate Python data types, as follows:.
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 |