Can we load ENV variable into VERTICA columns?

Comments

• Navin_C ✭

  September 2013

  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.

  0