Skip site navigation (1) Skip section navigation (2)

Re: indexes and relationships

From: Bob McConnell <rmcconne(at)lightlink(dot)com>
To: bill house <wchouse(at)bellsouth(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: indexes and relationships
Date: 2009-12-27 22:35:31
Message-ID: 4B37E133.3000708@lightlink.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

pgsql-novice by date

Next:From: JORGE MALDONADODate: 2009-12-28 22:58:59
Subject: CHILD WITHOUT PARENT (TEMPORARILY)
Previous:From: bill houseDate: 2009-12-27 19:06:31
Subject: indexes and relationships

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group