[postgis-users] spatial operations on tables in different db

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>