[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Questions re database schema:street:address:urb:count
Re: [Gnumed-devel] Questions re database schema:street:address:urb:country
Mon, 30 Aug 2004 21:08:41 +1000
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
Almost good, but it comes better: Newer postgres versions support table name
You create a name space "demographics", and then access the table "country"
within that namespace via "demographics.country"