foreign key help - Mailing list pgsql-general

From Dale Sykora
Subject foreign key help
Date
Msg-id 4238B4B3.8060904@czexan.net
Whole thread Raw
List pgsql-general
I am building a database that has about 20 fields in various tables that
  I would like to constrain to a small group (<=5) of choices.  Rather
that refer to 20 seperate tables, I would like to refer to 1 table that
contained category and choice fields.

for example

choices table

category | choice
-----------------
color    | red
color    | green
size     | small
size     | big
shape    | circle
shape    | square

item table

item     |  shape
-----------------
box      |  constrain to choices(choice) where category='shape'



Is there an easy way to do this, or is it better to have many
choices_category tables?

Thanks,

Dale



pgsql-general by date:

Previous
From: Miroslav Šulc
Date:
Subject: Re: psql file restore - problem with encoding (solved)
Next
From: "Andrew B. Lundgren"
Date:
Subject: search_path, schemas and functions...