<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial>Andrea,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial>Yes. But its kind of slow when doing joins and can't use
spatial index so wouldn't recommend it.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial>To do that I use db_link but its best just for small returns
or for bulk inserts.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html">http://www.postgresonline.com/journal/index.php?/archives/44-Using-DbLink-to-access-other-PostgreSQL-Databases-and-Servers.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617202309-09102009><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><FONT color=#0000ff size=2
face=Arial></FONT><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Andrea Peri<BR><B>Sent:</B> Friday, October 09, 2009 3:01 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> Re: [postgis-users]
Install postgis on a different schema<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR>Regina<BR><BR>thx for hints.<BR><BR>I think you have
right.<BR><BR>Is better to install on different databases.<BR>And I move
definitively on this choice.<BR><BR>Only a last question<BR>As you know is
possible from inside a session on a database to read <BR>geometry data on
another table on another database (same postgres instance of
course).<BR><BR>Regards,<BR><BR>Andrea.<BR><BR>>In theory you can but you
shouldn't. It would get very confusing and you<BR>>would quickly loose
your sanity as you would have to schema qualify each<BR>>postgis function,
geometry type etc and it wouldn't work with any third<BR>>party tools
correctly because they most likely will not schema qualify. I<BR>>would
avoid it.<BR><BR clear=all><BR>-- <BR>-----------------<BR>Andrea Peri<BR>. . .
. . . . . . <BR>qwerty אטלעש<BR>-----------------<BR><BR></BODY></HTML>