string primary key - Mailing list pgsql-general

From Mark Gibson
Subject string primary key
Date
Msg-id 44635DC9.1020206@gibsonsoftware.com
Whole thread Raw
Responses Re: string primary key  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: string primary key  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
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?

My instinct tells me that an integer is preferred, but I'm looking for a
more concrete answer.

Thanks,
Mark

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Debugging SQL queries
Next
From: Scott Marlowe
Date:
Subject: Re: string primary key