back to first page[..][[BR]]
back to ["BDMAP"][[BR]]

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

= Download and load the data BDMAP from sauv_BDMAP_31072010.backup=

I have created a new database : BDMAP2[[BR]]
There are columns : [[BR]]

In cmd console :[[BR]]
{{{
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 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 :[[BR]]
   * 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 bdmap2.bdmap;
      ALTER TABLE classe_taille_taxon SET SCHEMA bdmap;
      ALTER TABLE entitehydro SET SCHEMA bdmap;
      ALTER TABLE geometry_columns 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 spatial_ref_sys 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;
}}}

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

}}}