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:
@ECHO OFF 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.
Tagged:
0
Answers
Try using -A instead of -At ?