The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.