[postgis-users] PostGIS schemas

[Gaby]

Hi there

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. I am a complete novice at PostGIS. 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.
Please note the following background:
- I am doing all of the work on a standalone machine that I use as both client and server.
- I am running Windows XP SP2

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:
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?)
b. How I can create multiple PostGIS connections, each from a different schema?

Yours Sincerely

Gaby van Wyk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050711/699126b8/attachment.html>