Same db and different schemas. Dblink wouldn't be able to take advantage of spatial indexes between 2 databases and that would really be the only way you Can do a cross query between 2 databases.
Hoep that helps, Regina http://www.postgis.us > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On > Behalf Of Mr. Puneet Kishor > Sent: Thursday, September 01, 2011 5:01 PM > To: PostGIS Users Discussion > Subject: [postgis-users] spatial operations on tables in different db > > potentially dumb question: > > Kinda follows up on > [http://postgis.refractions.net/pipermail/postgis-users/2009-N > ovember/025211.html] "Install postgis on a different schema" > but slightly different -- Can I do spatial operations > involving tables in different databases? Or, should I just > store them in the same db, but in different schemas? > > -- > Puneet Kishor > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
