Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
What is the best way to extract meta-data from Vertica in standard SQL format?
Given a large database with lots of tables etc., what is the best way to extract the meta-data for those objects in order to use said meta-data to define objects in another Vertica database or a different DB altogether?
Using the formatting options of vsql does not seem to do quite what I want without some extensive editing afterwards.
Thank you, John
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Thank you!
The following example exports all the non-virtual objects to which the user has access to standard output. The example uses
false
for the last parameter, indicating that the file will not include theMARK_DESIGN_KSAFE
statement at the end.