Vertica DDL for Objects

Steve_Angell

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

[Deleted User]

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);

[Deleted User]

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

Steve_Angell

Thats fine thank you, just trying to understand how vertica works !

[Deleted User]

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