Changes between Version 40 and Version 41 of CookBook join BDMAP_CCM v2

Timestamp:

Nov 9, 2010 3:53:29 PM (14 years ago)

Author:

cedric

Comment:

--

CookBook join BDMAP_CCM v2

@@ -116 +116 @@
 }}}
 at this stage it is usefull to check the geometry column table and correct it eventually
-=== 32. project stationsp2 again ===
+=== 32. project stationsp2 again and get table of all projections within 300 ===
 
 Some stations were missing...
@@ -159 +159 @@
 CREATE INDEX indexbd_map_bd_carthage ON bd_map_bd_carthage
   USING GIST ( the_geom GIST_GEOMETRY_OPS );
+}}}
 
+=== 33. Saving back table stationsp2 from bd_carthage to eda ===
+
+{{{
+cd C:\eda\backup
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 -t bd_map_bd_carthage bd_carthage> bd_map_bd_carthage.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0 -p 5433 -U postgres -f bd_map_bd_carthage.sql
+REM une erreur quand il essaye de mettre le schéma bd_map mais là on a pas besoin d'avoir les données dans un schéma
 }}}