[postgis-users] PostGIS schemas

[Gustavo Henrique Sberze Ribas]

Hello,

> 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?)

 Because both programs list all the entries in the geometry_columns table. 
Since geometry_columns is in the Public schema, any user has access to
it (usually). 
 The geometry_columns table acts as a reference to all spatial tables
in your database. An entry is automatically created when you invoke
addGeometryColumn(...) on a table.
  

--
Gustavo


> 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.
>