Postgres Pro
Downloads
Home   >   mailing lists

Re: UUID column as pimrary key? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: UUID column as pimrary key?
Date
Msg-id 1294169070.6949.39.camel@jd-desktop
Whole thread Raw
In response to UUID column as pimrary key?  (Dennis Gearon <gearond@sbcglobal.net>)
List pgsql-general
Tree view 
On Tue, 2011-01-04 at 11:07 -0800, Dennis Gearon wrote:
> I haven't been able to find anywhere, easily, in the documentation using google
> where a list of allowed data types for primary keys is.

Anything that can be UNIQUE NOT NULL

>
> So, UUIDs can be primary keys?

Yes.

JD


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: UUID column as pimrary key?
Next
From: David Wall
Date:
Subject: Re: UUID column as pimrary key?