back to first page..
back to BDMAP

We got some problems with the version of BDMAP (export_BDMAP_pgsql_05022010.backup), all the values were rounded.

Download and load the data BDMAP from sauv_BDMAP_31072010.backup

I have created a new database : BDMAP2
There are columns :

In cmd console :

C:\"Program Files"\PostgreSQL\8.4\bin\psql -p 5432 -U postgres -c "CREATE DATABASE bdmap2  WITH OWNER = postgres  template=postgis ENCODING = 'UTF8'  LC_COLLATE = 'French_France.1252'  LC_CTYPE = 'French_France.1252' CONNECTION LIMIT = -1;"
cd D:\CelineJouanin\BDMAP
C:\"Program Files"\PostgreSQL\8.4\bin\pg_restore.exe --host localhost --port 5432 --username postgres --dbname "bdmap2" --verbose "D:\CelineJouanin\BDMAP\sauv_BDMAP_31082010.backup"

New tables can be find in BDMAP2 :

• mensurationindiv
• ssecteur_hydro
• zonepeche

• Create schema bdmap et changement de schéma des différentes tables sous public -- mais je pense qu'il y a un autre moyen de faire cela !!!

      --- In sql editor 
      CREATE SCHEMA bdmap;
      ALTER TABLE classe_taille_taxon SET SCHEMA bdmap;
      ALTER TABLE codier SET SCHEMA bdmap;
      ALTER TABLE entitehydro SET SCHEMA bdmap;
      ALTER TABLE i_entitehydro SET SCHEMA bdmap;
      ALTER TABLE lotpeche SET SCHEMA bdmap;
      ALTER TABLE mensurationindiv SET SCHEMA bdmap;
      ALTER TABLE operation SET SCHEMA bdmap;
      ALTER TABLE optaxon SET SCHEMA bdmap;
      ALTER TABLE passtaxon SET SCHEMA bdmap;
      ALTER TABLE ssecteurhydro SET SCHEMA bdmap;
      ALTER TABLE station SET SCHEMA bdmap;
      ALTER TABLE tableauclassetaille SET SCHEMA bdmap;
      ALTER TABLE taxon SET SCHEMA bdmap;
      ALTER TABLE tronconhydro SET SCHEMA bdmap;
      ALTER TABLE unitehydro SET SCHEMA bdmap;
      ALTER TABLE version SET SCHEMA bdmap;
      ALTER TABLE zonepeche SET SCHEMA bdmap;
      COMMENT ON SCHEMA bdmap IS 'created from dump by Laurent, 01/09/2010, this version solves problems with integer and rounded values'

Autre manière d'intégrer les données depuis le backup dans bdmap2.bdmap