Andrea, Yes. But its kind of slow when doing joins and can't use spatial index so wouldn't recommend it. To do that I use db_link but its best just for small returns or for bulk inserts. http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to -access-other-PostgreSQL-Databases-and-Servers.html Hope that helps, Regina
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Andrea Peri Sent: Friday, October 09, 2009 3:01 AM To: [email protected] Subject: Re: [postgis-users] Install postgis on a different schema Hi, Regina thx for hints. I think you have right. Is better to install on different databases. And I move definitively on this choice. Only a last question As you know is possible from inside a session on a database to read geometry data on another table on another database (same postgres instance of course). Regards, Andrea. >In theory you can but you shouldn't. It would get very confusing and you >would quickly loose your sanity as you would have to schema qualify each >postgis function, geometry type etc and it wouldn't work with any third >party tools correctly because they most likely will not schema qualify. I >would avoid it. -- ----------------- Andrea Peri . . . . . . . . . qwerty àèìòù -----------------
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
