Re: unique ID

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: sql(at)aniota(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: unique ID
Date: 2004-07-23 15:54:38
Message-ID: 20040723155438.GB17787@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Jul 23, 2004 at 06:56:49 -0700,
sql(at)aniota(dot)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).

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Luiz K. Matsumura 2004-07-23 16:00:31 String Concatenation
Previous Message sql 2004-07-23 13:56:49 unique ID