We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Export Data with BELL character delimiter — Vertica Forum

Export Data with BELL character delimiter

Dear Lister - Im trying to export data into .del files with  BELL character delimiter.

not sure correct syntax for " BELL character delimiter" current using '\u007'.. which is now working. 

 

vsql -U dbadmin -F '\u0007' -A -o /home/dbadmin/cnp_prime_opportunity_1_1a.del -c "select * from  dburmist.cnp_prime_opportunity_1_1a;"; 

 

Could you please some one tell me what is the right syntax to extract data with "BELL character delimiter". 

Much appreciate for your response. Thanks

 

-arathinas

 

Comments

  • Hi All.. 

    I got the answer for this question.. 

     

    vsql -U dbadmin -w vrtdba -F $'\7' -A -o /home/dbadmin/cnp_prime_opportunity_1_1a.del -c "select * from  dburmist.cnp_prime_opportunity_1_1a ;";

Leave a Comment

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