Loading data from table to file

Hii Harish, You can do it by using \o command. Eg: i have a table named TEST_TABLE now i want to generate a comma separated data from this table. for that do as follows.. \o /home/dbadmin/TEST_TABLE.txt; select * from TEST_TABLE; DONE!! Now search the file in the path /home/dbadmin Regards, Raj!!!

Harish, Prior to the above statements, you need to do some file alignment settings. \a for alignment \f for separator Eg: comma, pipe, tab Regards, Raj

From unix prompt $/opt/vertica/bin/vsql -U dbadmin -A -t -F'|' -h -c "select * from " > /tmp/export.txt

but for the dbadmin it will be asking for password i want the password also encrypted in the same command.

> vsql -U username -F $'\t' -At -o dumpfile.txt -c "SELECT * FROM my_table;"

Password:

i want to enter the password also in the same command.
My scenario this command fires on vertica db through a jdbc driver. for that i am writing a shell script to open vsql and fire this query and come out of vsql

use this from unix terminal

vsql -U username -w password -F $'\t' -At -o dumpfile.txt -c "SELECT * FROM my_table;"

Hope this helps.