[Gnumed-devel] postgres schema

[Horst Herb]

Since version 7.3, PostgreSQL allows the use of schemas, which is sort of a 
namespace implementation for tables etc.

It would allow us to consistently name administrative tables (audit etc) the 
same way, regardless of whether these tables are located in the same database 
or distributed.

example:
create schema prescriptions;
create schema person;
create table prescriptions.autdit(...)
create table person.audit(...)

"Schema" is a SQL92 feature, nothing esoteric. It allows further to implement 
access permissions at a higher level than granting for each single table 
indvidually, which adds security (in case a developer forgets to set adequate 
permissions for a new table, the grossest security problems would be caught 
by the schema permissions)

I opt for using schemas. Anybody against it? If so, why?

Horst