Changes between Version 4 and Version 5 of CookBook pgsql2shp

Timestamp:

Jun 10, 2010 5:47:57 PM (15 years ago)

Author:

cedric

Comment:

--

CookBook pgsql2shp

@@ -31 +31 @@
   -? Display this help screen.
 }}}
+
+the gid is not loaded into the database so I thing we shoud use -r option
+We do not want shifts to maj so we should be using the -k option
 == ccm21.riversegments_bretagne ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\riversegments_bretagne" -p 5433 -u postgres -P postgres -g the_geom eda2.0 ccm21.riversegments_bretagne
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\riversegments_bretagne" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 ccm21.riversegments_bretagne
 }}}
 == ccm21.catchments_bretagne ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\catchments_bretagne" -p 5433 -u postgres -P postgres -g the_geom eda2.0 ccm21.catchments_bretagne
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\catchments_bretagne" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 ccm21.catchments_bretagne
 }}}
 == clc.clipped_bretagne1 ==
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\clipped_bretagne1" -p 5433 -u postgres -P postgres -g the_geom eda2.0 clc.clipped_bretagne1
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\clipped_bretagne1" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 clc.clipped_bretagne1
 }}}
 == ccm21.riversegments_france ==
 A query selecting a reduced area
 {{{
-C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\riversegments_france" -p 5433 -u postgres -P postgres -g the_geom eda2.0 "select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France');"
+C:\"Program Files"\PostgreSQL\8.4\bin\pgsql2shp -f "C:\Documents and Settings\cedric\Mes documents\Migrateur\eda\exports_shape\riversegments_france" -p 5433 -u postgres -P postgres -g the_geom -r -k eda2.0 "select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France');"
 }}}