[postgis-users] Database Design for many tables

[Josh@oklieb]

Schemas in PostgreSQL, as in other DBMS' such as Oracle, are  
namespaces with associated permissions, specifically to allow  
database operations across groups of objects separated for naming and  
permission purposes.

Assuming permission has been granted to operate on two schemas, any  
objects from both schemas should be usable together, including  
operators, by prefixing them with the appropriate schema name.

It should be the database not the individual schemas which are  
spatially enabled. The operators seem to b schema-aware now (since  
1.0.1?) but may need to be prefixed (e.g. "public.") to be used in  
other schemas in each database, depending on whether they are  
unambiguous. Some of the spatial operators take an explicit schema  
parameter as well (e.g. AddGeometryColumn). See the docs for particulars

Cheers,

Josh

Joshua Lieberman, Ph.D.
Principal, Traverse Technologies Inc.
mailto:jlieberman at traversetechnologies.com
tel +1 (617) 395-7766
fax: +1 (815) 717-981


On Jan 5, 2007, at 9:25 PM, Dylan Beaudette wrote:

> On Friday 05 January 2007 17:35, Webb Sprague wrote:
>> On 1/5/07, Paul Ramsey <pramsey at refractions.net> wrote:
>>> Are schemas not useful here?
>>>
>>> <http://www.postgresql.org/docs/8.1/interactive/ddl-schemas.html>
>>>
>>> From a design standpoint, maybe maybe not.  If you already know that
>>
>> schemas make your design better, sure. I tend to shy away from
>> breaking things into lots of little pieces without a really good
>> reason.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> I have looked over this manual page in the past, perhaps it didn't  
> sink in.
> The main question that I have would then be: is a single instance  
> of the
> postgis extension all that is required to allow spatial operations  
> between
> two or more schemas? I have brought the topic up before, but was  
> never able
> to sort it out nor ask the right questions [1] .
>
> 1. link to thread here:
> http://postgis.refractions.net/pipermail/postgis-users/2006- 
> November/013911.html
>
> Cheers,
>
> -- 
> Dylan Beaudette
> Soils and Biogeochemistry Graduate Group
> University of California at Davis
> 530.754.7341
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070105/48f43f4c/attachment.html>