<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2668" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi there</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am investigating the use of PostGIS with both
uDig and Quantum GIS. I should add that I come out of an Oracle Spatial
background. </FONT><FONT face=Arial size=2>I am a complete novice at
PostGIS. </FONT><FONT face=Arial size=2>I have converted 5 different data
sets with a total of 65 SHP files. For practical reasons I want to
keep the tables from each dataset in different schemas.</FONT></DIV>
<DIV><FONT face=Arial size=2>Please note the following background:</FONT></DIV>
<DIV><FONT face=Arial size=2>- I am doing all of the work on a standalone
machine that I use as both client and server.</FONT></DIV>
<DIV><FONT face=Arial size=2>- I am running Windows XP SP2</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Now the problem; in both of the products I am
trying (uDig and Quantum GIS), I can view all of the tables from all of the
schemas when logged on as schema owner of any one schema. However, as expected,
I can only view the data from the schema I logged on as. This leads me to
the following questions:</FONT></DIV>
<DIV><FONT face=Arial size=2>a. Why is it that after logging on as a particular
user/schema owner, I can list ALL of the tables, regardless of the schema they
belong to? (I suspect that since both products work the same that it is a
PostGIS / PostGreSQL anomaly, not problems with uDig or Quantum
GIS?)</FONT></DIV>
<DIV><FONT face=Arial size=2>b. How I can create multiple PostGIS connections,
each from a different schema<EM>?</EM></FONT></DIV>
<DIV><EM><FONT face=Arial size=2></FONT></EM> </DIV>
<DIV><FONT face=Arial size=2>Yours Sincerely</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gaby van Wyk</FONT></DIV></BODY></HTML>