Re: string primary key

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Mark Gibson <mark(at)gibsonsoftware(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: string primary key
Date: 2006-05-12 06:54:17
Message-ID: 20060512065417.GB9151@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 11, 2006 at 09:52:41 -0600,
Mark Gibson <mark(at)gibsonsoftware(dot)com> wrote:
> Is there a disadvantage to having the primary key for a table be a text
> type vs. an integer type? Performance? Any difference between having a
> varchar or char as a primary key?

You probably want to use 'text' unless there is a busniess rule limiting
the size of the field.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2006-05-12 07:05:23 Re: string primary key
Previous Message Tony Caduto 2006-05-12 03:32:30 Re: GUI Interface