Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Unaligned output, no messages, retain headers

I can find no combination of flags which allow me to retain headers but lose the message at the bottom of query output. [[email protected] ~]$ vsql -w dbadmin -A -c "select 1 as a" a 1 (1 row) [[email protected] ~]$ vsql -w dbadmin -t -A -c "select 1" 1 What I want is a 1 can be solved with awk, tail etc, but it seems like this would be the most natural way to output a csv and I can't seem to find a way.

Comments

  • You use the -P footer= on the vsql command line to set the footer to be empty. This is the same as using \pset footer from within vsql itself. example: vsql -A -c "select 1 as a" -P footer= a 1

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.