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
+2
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 the MARK_DESIGN_KSAFE statement at the end.
=> SELECT EXPORT_OBJECTS(' ',' ',false);
see the link for more details:
https://my.vertica.com/docs/6.1.x/HTML/index.htm#12721.htm
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
