Skip to main content

Can we load ENV variable into VERTICA columns?

  • September 27, 2013
  • 1 reply
  • 7 views
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

    1 reply

    Navin_C
    Forum|alt.badge.img+2
    • Navin_C
    • Participating Frequently
    • September 29, 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.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement