Export data into cvs format from Vertica using the vsql Meta-Commands

Just to play around and maybe someday this can be useful to any of you we will see how can we export a result set from Vertica into a csv file using Vsql Meta-Commands.

What are the meta-commands ?

“Anything you enter in vsql that begins with an unquoted backslash is a vsql meta-command that is processed by vsql itself. These commands help make vsql more useful for administration or scripting. Meta-commands are more commonly called slash or backslash commands.”

Let’s get on with our simple example:

 

I hope that was helpful

   

I hope this was helpful and i appreciate if you would like, subscribe or share our posts. I it is just a click

clickhere

Similar Article  How to get the raw size of your data in HP Vertica
No Comments
Leave a Comment

%d bloggers like this: