Search Postgresql Archives

Re: string primary key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 11, 2006 at 09:52:41 -0600,
  Mark Gibson <mark@xxxxxxxxxxxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux