Re: [Gnumed-devel] Questions re database schema:street:address:urb:country

[Horst Herb]

On Mon, 30 Aug 2004 08:22, Richard Terry wrote:
> Imagine the following scenario. At the moment gnuMed (yet in its infancy)
> has in only a tiny part of the database over 160 tables, which read like a
> dogs breakfast. We should be aiming to visually keep all similar data
> together ie same sort of object heirachy that one should be using in
> descriptive terms in the python code:
>
> eg    demographics_country
>         demographics_states
>         demographics_streets

Almost good, but it comes better: Newer postgres versions support table name 
spaces.
You create a name space "demographics", and then access the table "country" 
within that namespace via "demographics.country" 

Horst