Can we load ENV variable into VERTICA columns?

chandra_1

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

Navin_C

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.