The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to export Vertica query to a CSV file by using command line (CMD) in header format?

Hey folks!

I've problem here, i'm using a batch file where makes me able to export data from a table In Vertica Data base remotely. It works, but somehow the CSV file has a strange format like this:

I mean it has $ sign at the end and single quotes instead headers, here is my command lines code:

set VSQL_USER=user
set VSQL_PASSWORD=password
set VSQL_HOST=host
set VSQL_DATABASE=databasename
vsql -F $',' -At -o C:\Users\geradiaz.MODELO\Desktop\Icaro\Ventas\Output_Azure\sample_table_output.csv -c " select * from ModeloBI.CORP.ventas limit 10;"

Do you know guys, how to change the format to header command? something like (format csv,header) in postgreSQL

thanks for your time.


Leave a Comment

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