Re: unique ID - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: unique ID
Date
Msg-id 20040723155438.GB17787@wolff.to
Whole thread Raw
In response to unique ID  (sql@aniota.com)
List pgsql-novice
On Fri, Jul 23, 2004 at 06:56:49 -0700,
  sql@aniota.com wrote:
> I am starting to build an internet directory. What type of system
> generated unique ID would you suggest?

I am not sure that it makes sense to generate an ID for this purpose,
rather than using a URL, email address or whatever else makes sense
for your directory as the primary key.
However, if you do want one, you want to use bigserial (the in4 serial
might not be big enough for your purpose).

pgsql-novice by date:

Previous
From: sql@aniota.com
Date:
Subject: unique ID
Next
From: "Luiz K. Matsumura"
Date:
Subject: String Concatenation