Changes between Version 84 and Version 85 of CookBook join BDMAP_CCM
- Timestamp:
- Mar 23, 2010 11:17:04 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join BDMAP_CCM
v84 v85 164 164 C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump -U postgres -p 5433 -t stationsp2 BDMAP> stationsp2.sql 165 165 }}} 166 Restore the file in the ''' CCM_EDA ''' database, suppress the stationsp2 table if it already exists 167 {{{ 166 Restore the file in the ''' ccm21_eda ''' database, suppress the stationsp2 table if it already exists 167 {{{ 168 REM Cédric ======================= 168 169 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -p 5433 -U postgres -f stationsp2.sql 169 170 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -p 5433 -U postgres -c "create schema bd_map" 170 171 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -p 5433 -U postgres -c "ALTER TABLE stationsp2 set schema bd_map" 172 REM Céline ======================= 173 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -p 5432 -U postgres -f stationsp2.sql 174 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -p 5432 -U postgres -c "create schema bd_map" 175 C:\"Program Files"\PostgreSQL\8.4\bin\psql -d ccm21_eda -p 5432 -U postgres -c "ALTER TABLE stationsp2 set schema bd_map" 171 176 }}} 172 177 Don't forget to change the port into 5432 (celine)