bill house wrote:
> 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
> 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
In response to
pgsql-novice by date
|Next:||From: JORGE MALDONADO||Date: 2009-12-28 22:58:59|
|Subject: CHILD WITHOUT PARENT (TEMPORARILY)|
|Previous:||From: bill house||Date: 2009-12-27 19:06:31|
|Subject: indexes and relationships|