Diskuse:Cvičná databáze PostGIS

Poznámky pro administraci

osm_routing

./osm2pgrouting -file ~/czech-republic-latest.osm -conf mapconfig.xml -dbname pgis_osm_rouring_new -user landa -passwd ...

ALTER TABLE classes SET SCHEMA osm_routing;
ALTER TABLE nodes SET SCHEMA osm_routing;
ALTER TABLE relation_ways SET SCHEMA osm_routing;
ALTER TABLE relations SET SCHEMA osm_routing;
ALTER TABLE types SET SCHEMA osm_routing;
ALTER TABLE way_tag SET SCHEMA osm_routing;
ALTER TABLE ways SET SCHEMA osm_routing;