Changes between Version 1 and Version 2 of Temperature download and load


Ignore:
Timestamp:
May 11, 2010 10:22:21 AM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Temperature download and load

    v1 v2  
    2222== Create the table in Postgre to import to == 
    2323=== Import the temperature tmp (temperature moyenne)=== 
     24{{{ 
     25DROP TABLE IF EXISTS temperature.tmp; 
     26}}} 
     27["Create table tmp"] 
     28{{{ 
     29COPY temperature.tmn FROM 'D:/Celine Jouanin/Temperature/tmp.txt' USING DELIMITERS ';' CSV HEADER; 
     30}}} 
    2431 
    2532=== Import the temperature tmx (temperature maximum) === 
     33{{{ 
     34DROP TABLE IF EXISTS temperature.tmx; 
     35}}} 
     36["Create table tmx"] 
     37{{{ 
     38COPY temperature.tmx FROM 'D:/Celine Jouanin/Temperature/tmx.txt' USING DELIMITERS ';' CSV HEADER; 
     39}}} 
    2640 
    2741=== Import the temperature tmn (temperature minimum) ===