Changes between Version 3 and Version 4 of Station Hydro

Timestamp:

Mar 5, 2012 3:28:55 PM (13 years ago)

Author:

celine

Comment:

--

Station Hydro

@@ -43 +43 @@
 
 -- Récupération des attributs Rht --
+drop table if exists pate.station_hydro_rhtvs2;
 create table pate.station_hydro_rhtvs2 as (
-        select s.*, a.module_icinf, a.module, a.module_icsup, a.surf_bv, r.dmer, r.dsource from pate.station_hydro s 
+        select s.*, a.module_icinf, a.module, a.module_icsup, a.surf_bv, r.dmer/1000 as dmer, r.dsource/1000 as dsource from pate.station_hydro s 
         join rht.rhtvs2 r on s.id_drain=r.id_drain
         join rht.attributs_rht_fev_2011_vs2 a on s.id_drain=a.id_drain);
@@ -51 +52 @@
 update pate.station_hydro_rhtvs2 set drelative=dmer/(dmer+dsource)*100;
 
+COPY pate.station_hydro_rhtvs2 TO 'D:/CelineJouanin/PATE/Station_Hydro_rhtvs2.csv' with csv header delimiter as ';'
+
 }}}