[postgis-users] PostGIS schemas

[Jan Hartmann]

Hi Gaby,

I can only answer your second question:

 > b. How I can create multiple PostGIS connections, each from a
 > different schema/?/

You can set the search_path to whatever schema(s) you want in the 
connection string:

CONNECTION "dbname=mydb options='-c search_path=myschema,public'"

The "public" schema has to be in the search_path, else PostGIS won't 
find its geometry_columns and spatial_ref_sys tables.

Jan

Gaby wrote:
> 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users