Changes between Version 21 and Version 22 of CookBook join ROE_CCMv2

Timestamp:

Nov 19, 2010 4:39:13 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join ROE_CCMv2

@@ -404 +404 @@
 {{{
 #!sql
+/*
+* BUILDING THE TABLE WITH RIGHT IDS
+*/
+drop table if exists geobs2010.obstacle_referenciel_projccm;
 create table geobs2010.obstacle_referenciel_projccm as(
 select 
@@ -420 +424 @@
  from geobs2010.roe_ccm_500_final rc5f 
 inner join ccm21.riversegments rs on rc5f.gid=rs.gid
-inner join geobs2010.obstacle_referentiel oref on oref.ref_id=rc5f.ref_id limit 10);
+inner join geobs2010.obstacle_referentiel oref on oref.ref_id=rc5f.ref_id );
 comment on table geobs2010.obstacle_referenciel_projccm is 'table created 19 novembre 2010 by Cédric';
 comment on column geobs2010.obstacle_referenciel_projccm.ref_id is 'ref id du roe';
@@ -435 +439 @@
 comment on column geobs2010.obstacle_referenciel_projccm.manual_insert is '1= Barrages réinsérés à la main après examen des cartes, 0 sinon';
 }}}
-
+{{{
+REM SAUVEGARDE ET RESTAURATION FRANCOIS (LA PREMIERE EST INUTILE
 cd C:\eda\backup
-C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 -t geobs2010.obstacle_referenciel_projccm eda2.0> geobs2010.obstacle_referenciel_projccm.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 -t geobs2010.obstacle_referenciel_projccm eda2.0> geobs2010.obstacle_referenciel_projccm.sql 
+
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 -t geobs2010.obstacle_referenciel eda2.0> geobs2010.sql
+
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 --schema=geobs2010 eda2.0> geobs2010.sql
+
+REM RESTAURATION 
+cd c:\base
+C:\"Program Files"\PostgreSQL\8.4\bin\psql\ -U postgres -d eda2.0 -p 5432 -U postgres -f geobs2010.sql
+}}}