Skip to main content

How to Get Projection definition ?

  • January 4, 2016
  • 2 replies
  • 6 views

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

 

2 replies

eli_revach
Forum|alt.badge.img+2
  • Participating Frequently
  • January 4, 2016

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
  • Author
  • New Participant
  • January 6, 2016

Thanks, it worked.