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
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
Try using -A instead of -At ?