Re: indexes and relationships

bill house wrote:
> Hello,
>
> I am new to sql of any sort. I have selected postgresql to learn and am
> in the process of trying to train myself. I am using 8.3 on linux.
>
> My first self assignment is to get the data from the nutritional
> database published by USDA into a postgresql database.
>
> This database is available at
>
> http://www.nal.usda.gov/fnic/foodcomp/search/
>
> at a button at the bottom when it isn't busy.
>
> Based on their documentation I have created the tables, converted the
> text files to csv files and inserted the data.
>
> Now I am in the process of setting up the relationships.

There was a group discussion on using an earlier version of this
database in a Drupal project. They were using MySQL, but you may benefit
from some of their discussions. The thread is at

<http://drupal.org/node/107806>

Bob McConnell
N2SPP