A few more comments on your table design.
Stefan Schwarzer skrev:
> So, instead of the earlier mentioned database design, I would have
> something like this:
> - one table for the country names/ids/etc. (Afghanistan, 1; Albania,
There is a well-established natural key for countries - ISO 3166. Use
that instead of "id".
> - one table for the variable names/ids/etc. (GDP, 1; Population, 2;
> Fish Catch, 3;....)
> - one table for the years names/ids/etc. (1970, 1; 1971, 2; 1973, 3;
No need for an ID column on this one. Just use the year as the primary key.
In response to
pgsql-general by date
|Next:||From: Richard Huxton||Date: 2007-09-28 09:21:20|
|Subject: Re: Normalized Tables & SELECT [was: Find "smallest common
|Previous:||From: Tom Allison||Date: 2007-09-28 09:09:13|
|Subject: Re: Debian problem...|