How to see object metadata in a Vertica database (e.g. Oracle)

Question

I would like to know how I can get the metadata of an object in a Vertica database; like table metadata. Is there a table that stores object metadata (functions, views, tables) in the Vertica database.
For example, in Oracle, I can enter the following and get a detailed description of the tables or see the procedure code.
oracle :> desc table_name;
or
oracle :> edit proc_name;

I know that I see tables from my schemas using the \dt command, but is there a way to see the DDL actions that the objects created?

Answer 1

\d table-name should provide you with what you need.

Answer 2

Thanks, but that’s not what I want. I was looking for the export_objects() function:

 select export_objects('','object_name') 

This way you get a script creation for the object.

Answer 3

Additional tip: if you specify only the scheme, you will get all the objects inside this scheme. Of course, the bits should introduce a loop in which you run export_objects () for each object.