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

Re: Fw: (orig posted to usenet) Advice req for restricting entry values]

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: cmasters(at)nbnet(dot)nb(dot)ca, pgsql-nov <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Fw: (orig posted to usenet) Advice req for restricting entry values]
Date: 2002-06-17 19:02:34
Message-ID: 200206171202.34997.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
C. Masters,

> I'm attempting to design a database for use in a library (loan) setting.
> Although I'm a novice psql user, I have had previous experience in data
> mangement during the "good 'ol" text entry days.
> 
> Several of the fields have a limited set of possible values; as such, I
> would like to automate the initial population and subsequent entry of new
> records -- fields such as 'media', 'genre', 'interest', etc. I'd like
> some input regarding the most effective way to accomplish this task.

The relational way to do this is with reference tables and a Foriegn Key 
constraint.   Any good book on SQL database design will help you do this:

http://techdocs.postgresql.org/techdocs/bookreviews.php

-- 
-Josh Berkus


In response to

pgsql-novice by date

Next:From: Tony GriffithsDate: 2002-06-18 08:24:14
Subject: Client-side libraries for fmgr invocation
Previous:From: cmastersDate: 2002-06-15 21:20:28
Subject: Fw: (orig posted to usenet) Advice req for restricting entry values]

pgsql-general by date

Next:From: Dan WestonDate: 2002-06-17 19:08:34
Subject: Re: TEXT and NULL...
Previous:From: Joshua D. DrakeDate: 2002-06-17 18:43:58
Subject: Re: Clients for administration?

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