[postgis-users] dblink experiences? multiple geom copies in multiple databases

John Smith jayzee.smith at gmail.com
Fri Aug 10 14:05:00 PDT 2007


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



More information about the postgis-users mailing list