| 1 | cd C:\eda\backup |
|---|
| 2 | |
|---|
| 3 | C:\"Program Files"\PostgreSQL\8.4\bin\pg_dump -U postgres -p 5433 -t ccm21.riversegments eda2.0> riversegments.sql |
|---|
| 4 | cd C:\eda\backup |
|---|
| 5 | C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d eda2.0 -p 5433 -c "drop table ccm21.riversegments" |
|---|
| 6 | C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d eda2.0 -p 5433 -f riversegments_backup.sql |
|---|
| 7 | C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d eda2.0 -p 5433 -c "CREATE INDEX indexriversegments_wso_id ON ccm21.riversegments USING btree (wso_id);" |
|---|
| 8 | C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d eda2.0 -p 5433 -c "CREATE INDEX indexriversegments_wso1_id ON ccm21.riversegments USING btree (wso1_id);" |
|---|
| 9 | C:\"Program Files"\PostgreSQL\8.4\bin\psql -U postgres -d eda2.0 -p 5433 -c "CREATE INDEX indexriversegments_sp ON ccm21.riversegments USING GIST ( the_geom GIST_GEOMETRY_OPS );" |
|---|
| 10 | |
|---|
| 11 | |
|---|
| 12 | |
|---|
