Changes between Version 5 and Version 6 of RNABE download and load


Ignore:
Timestamp:
May 17, 2010 11:26:22 AM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RNABE download and load

    v5 v6  
    2020C:\"Program Files"\PostgreSQL\8.4\bin\shp2pgsql -s 3035 RWBody_Merge.shp RWBody > RWBody.sql 
    2121}}} 
     22    * Convert it into utf8  (as the database is posgis), in notepad, open the stationsp.sql file and convert it to utf8 
     23Encodage> Convertir en UTF-8 
    2224 
     25And save the file as : RWBodyutf8 
     26 
     27    * Use psql to restore the file while connecting to RNABE ... change the port if necessary (cedric : 5433) 
     28{{{ 
     29      C:\"Program Files"\PostgreSQL\8.4\bin\psql -d eda2.0.rnabe -h localhost -U postgres -p 5432 -f RWBodyutf8.sql  
     30}}}