Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.