How to Get Projection definition ?

Soumyabrata

Hi All,

 

I am new to Vertica and want to know if anything (like EXPORT_TABLES for tables) is there to get exact Projection definion of an existing Projection.

 

Thanks,
SK

 

eli_revach

Hi 

In vertica you can use the export_object() API to get what you look for . more info in :

 

http://my.vertica.com/docs/7.1.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/EXPORT_OBJECTS.htm

 

Thanks 

Soumyabrata

Thanks, it worked.