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.

Answers

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.