Re: string primary key - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: string primary key
Date
Msg-id 20060512065417.GB9151@wolff.to
Whole thread Raw
In response to string primary key  (Mark Gibson <mark@gibsonsoftware.com>)
Responses Re: string primary key  ("Martin Kuria" <martinkuria@hotmail.com>)
List pgsql-general
On Thu, May 11, 2006 at 09:52:41 -0600,
  Mark Gibson <mark@gibsonsoftware.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.

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: GUI Interface
Next
From: Bruno Wolff III
Date:
Subject: Re: string primary key