Changes between Version 5 and Version 6 of PATE France

Timestamp:

Apr 2, 2012 10:56:37 AM (13 years ago)

Author:

celine

Comment:

--

PATE France

@@ -48 +48 @@
 }}}
 
+Avec la version 3 d'obstacle
+{{{
+#!sql
+alter table rht.pate_france add column id_drain integer;
+update rht.pate_france set id_drain=null;
+
+update rht.pate_france set id_drain=sub.id_drain from (
+select rhtvs2_roev3.id_drain, rhtvs2_roev3.id_roe from rht.pate_france join rht.rhtvs2_roev3 on rhtvs2_roev3.id_roe=pate_france.id_roe) sub
+where sub.id_roe=pate_france.id_roe; --3390 lignes
+
+update rht.pate_france set the_geom=NULL;
+update rht.pate_france set the_geom=rhtvs2_roev3.the_geom from rht.rhtvs2_roev3 where rhtvs2_roev3.id_roe=pate_france.id_roe; --3390 lines
+}}}
+
 Version obstacle version 3
 {{{
+#!sql
 DROP TABLE IF EXISTS rht.rhtvs2_roev3;
 CREATE TABLE rht.rhtvs2_roev3 as (
@@ -105 +120 @@
 }}}
 
+Export table[[BR]]
+{{{
+#!sql
+cd d:\CelineJouanin\export_table\version2
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t rht.rhtvs2_roev3 eda2.0_RHT> rhtvs2_roev3.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5432 -t rht.rhtvs2_roev3_nbdams eda2.0_RHT> rhtvs2_roev3_nbdams.sql
+}}}