Skip to main content

How to Get Projection definition ?

  • Jan 4, 2016 10:41 AM UTC
  • 2 replies
  • 9 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
  • Jan 4, 2016 8:56 PM UTC

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
  • Jan 6, 2016 10:03 AM UTC

Thanks, it worked.