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

Vertica DDL for Objects

Can anyone tell me how to get ddl of objects and how to use export_objects function Which of Verticas Documents / books best describes how to use this functionality

Comments

  • The Administrator's guide, Copying and Exporting Data contains the export_object and export_catalog functions. Here is the link https://my.vertica.com/docs/6.1.x/HTML/index.htm#15581.htm The SQL reference manual also contains the syntax regarding the commands. For the export_objects for example, this is the link https://my.vertica.com/docs/6.1.x/HTML/index.htm#12721.htm From our Documentation. Example 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 MAKE_DESIGN_KSAFE statement at the end. => SELECT EXPORT_OBJECTS(' ',' ',false);
  • Hi Steve, The export_objects as you said is the function that you are looking for. You can do it : select export_objects('/tmp/table_ddl.sql','table_schema.table'); here it will export the ddl in the file /tmp/table_ddl.sql of the table table_shema.table. Here is the link to the documentation with more details. https://my.vertica.com/docs/6.1.x/HTML/index.htm#12721_1.htm Hope this helps, Eugenia
  • Thats fine thank you, just trying to understand how vertica works !
  • Register in my.vertica.com and take a look at the training. There are few videos that are free and gives you a good start point. Good luck! Eugenia

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.