trying to get view ddl using python
Moderator: NorbertKrupa
trying to get view ddl using python
We have a need to get the ddl for a view using python. However it comes back empty using select export_objects() since the view is apparently too large for the buffer. Thought about chunking thru the ddl using substr sections but cannot use substr on the meta function export_objects. Then thought perhaps use v_internal.vs_views the view_definition but it is truncated at 8192 bytes. Some where underlying the complete ddl is stored. Is there anyway to output that using an sql query that gets around the problems using export_objects()?
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: trying to get view ddl using python
What driver are you using?
Checkout vertica.tips for more Vertica resources.
Re: trying to get view ddl using python
Using the odbc driver that comes with vertica 7.0.0.0: libverticaodbc.so