pyodbc: export_objects returns nothing for schema

Moderator: NorbertKrupa

dbmsuser7
Intermediate
Intermediate
Posts: 71
Joined: Tue Jan 28, 2014 3:03 am

Re: pyodbc: export_objects returns nothing for schema

Post by dbmsuser7 » Wed Feb 26, 2014 11:27 pm

norbertk,

I got around it pretty easily using vsql directly, calling it using Python's subprocess module, and capturing stdout.

I was looking at the Vertica data type table, and both CHAR and VARCHAR can hold up to 65,000 bytes. I'm guessing that's what the problem is. Maybe one could create a table with a single column of type LONG VARCHAR (holds up to 32*10^6 bytes) and then select into that, and then retrieve from that.

I made the post even though I had a workaround just to make sure it wasn't me making a dumb mistake.

Post Reply

Return to “Python”