You can try the SISDB PostGIS/Oracle plugin for OpenJUMP (it's read-only):
   
http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=217237
 
it has schema support (instruction are inside the txt file inside the zip).
 
Bye
Paolo Rizzi
 

________________________________

Da: [EMAIL PROTECTED] per conto di Sampson, David
Inviato: ven 28/09/2007 15.40
A: [email protected]
Oggetto: [jump-users] JUMP and PostGIS and using Different Schemas



Hey Folks, 

I am going through the proces sof building some intro level tutorials and info 
fro DB Admins moving into the spatial world and spatial people moving into the 
DB world or Distributed GIS.

I am Using uDig and OpenJUMP as my viewers and editors. 

This is the general setup 

uDig 
OpenJump 
        PostGIS Extension 
Postgres/Postgis 
Atlas of Canada Data 


My Db setup includes a public schema and 6 others including 
* transpo 
* bathymetry 
* boundaries 
* hydrography 
* ice 
* sandbox 

The idea here is that I can give different permissions to different groups of 
people and organize the data into logical groups.

THE PROBLEM: 
------------------------ 
Using the PostGIS plugin I can read the features fine from any of the Schemas 
as long is use the usual SCHEMA.TABLE notation for the table entry.

However when I create a new table I can not use that notation. It looks for 
public.SCHEMA.TABLE which of course will not be found.

How can I use the multiple schema approach to managing my data using OpenJUMP. 
Is this a functionality that is yet to be added? Or does everyone just use the 
Public schema

A multi schema approach woked using SDE in past projects so I assume it should 
work in postgis. 

Any ideas? 


_______________________________________________
jump-users mailing list
[email protected]
http://lists.refractions.net/mailman/listinfo/jump-users

Reply via email to