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: (view raw, whole thread or download thread mbox)
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
> 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


Bob McConnell

In response to

pgsql-novice by date

Next:From: JORGE MALDONADODate: 2009-12-28 22:58:59
Previous:From: bill houseDate: 2009-12-27 19:06:31
Subject: indexes and relationships

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