PKs for dictionary tables

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: PKs for dictionary tables
Date: 2002-12-11 19:51:23
Message-ID: 010301c2a14e$af1f4ba0$de138f80@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a database in which there is a particular data tables that has a lot of dictionary (or lookup) tables hanging off of it. The dictionary tables do not currently have PKs. They consist merely of a list of values that are used to create drop down lists in an application.

Would it be more efficient to create PKs for these dictionary tables so that an integer value is stored in the main data table as opposed to a sting value?
Is there a preferred database standard?

Thanks
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-12-11 20:03:19 Re: PKs for dictionary tables
Previous Message Flavio Hallais 2002-12-11 19:50:02 initdb failed ...