Can we load ENV variable into VERTICA columns?

chandra_1 · September 2013

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 · 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.

We're Moving!

Create My New Community Account Now

Can we load ENV variable into VERTICA columns?

Comments

Leave a Comment