Changes between Version 2 and Version 3 of Download and load ROEversion2

Timestamp:

May 26, 2011 5:25:09 PM (14 years ago)

Author:

celine

Comment:

--

Download and load ROEversion2

@@ -1 +1 @@
 back to first page[..][[BR]]
-back to["Obstacle pressure"][[BR]]
+back to ["Obstacle pressure"][[BR]]
 
-= Download and load ROE version2 =
+= Download and load ROE geobs2010 version2 =
+
 {{{
 --Celine
@@ -23 +24 @@
 ALTER TABLE geobs2011.roe_v2 ADD CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 3035);
 }}}
+
+Change the name of the schéma geobs2010 (to keep the previous version before adding the latest version from Karl).[[BR]]
+Then:[[BR]]
+{{{
+cd D:\CelineJouanin\ROE2011
+C:\"Program Files"\PostgreSQL\8.4\bin\psql  -U postgres --dbname "eda2.0" -f "geobs2010.sql"
+}}}
+This new version is : geobs2011 (Karl dump), the last version used with the CCM is still geobs2010