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