Changes between Version 26 and Version 27 of dbeel

Timestamp:

Dec 23, 2010 9:50:18 PM (14 years ago)

Author:

cedric

Comment:

--

dbeel

@@ -35 +35 @@
 
 = inserting Western River Basin District (Ireland) =
+
+REM sauvegarde
+cd C:\eda\backup
+C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump  -U postgres -p 5433 --schema=wrbd -T wrbd.irish_catchments -T wrbd.irish_lakes -T wrbd.irish_water_bodies -T wrbd.outline_of_ireland -T wrbd.wfd_lakesegment_we -T wrbd.wfd_riversegment_we -T wrbd.wfd_riversubbasins_we eda2.0> eda2.0.wrbd.sql
+REM restauration, restoring the whole schema preserves indexes and foreign keys
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5433 -f eda2.0.wrbd.sql
+C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d dbeel -p 5433 -c 'create schema wrbd; alter table fish_fi set schema wrbd;alter table operation_op set schema wrbd;alter table 
+