[postgis-users] Install postgis on a different schema

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Andrea
Peri
Sent: Friday, October 09, 2009 3:01 AM
To: postgis-users at postgis.refractions.net
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 àèìòù
-----------------


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091009/7706eb0c/attachment.html>