postgresql doesn't support queries across multiple databases and postgis doesn't support multiple schemas, so how'd you guys do it? i've multiple projects needing same geom. do i create multiple geom copies in each database for joins? guess not, but if so how'd i best update that geom? any experience with dblink?
as i understand http://www.nabble.com/Multiple-Schemas-with-PostGIS-tf3014581.html#a8394314, you install postgis in one schema, (probably) put all geoms in that schema and simply reference it from other databases? can someone show a simple example. ascii art won't hurt ;) "if the data is related enough to be joined, it must be related enough to be in the same database" doesn't cut it. jzs _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
