The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Can we load ENV variable into VERTICA columns?

Hi I have a table which has has date column. Can i load the ENV variable into that column using COPY command. Chandra


  • Navin_CNavin_C Vertica Customer
    Hi Chandra, Yes you can load ENV variable value to a date column using COPY command Lets say you have a unix variable PROCESS DATE='2010-12-12' You can pass this variable to be a Vertica variable using the
       vsql -v PROC_DATE = $PROCESS_DATE -c     COPY table_name  (  column_process_date as :PROC_DATE  )  from path_of_file  delimiter '|'  ;  
    Hope this helps.

Leave a Comment

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