Re: Auto Increment - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: Auto Increment
Date
Msg-id Pine.LNX.4.30.0012262052360.16141-100000@chapelperilous.net
Whole thread Raw
In response to Auto Increment  (<postgres@flipper.webdevelop.net>)
Responses Re: Auto Increment  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Auto Increment  (<postgres@flipper.webdevelop.net>)
List pgsql-general
On Tue, 26 Dec 2000 postgres@flipper.webdevelop.net wrote:

>     Is there a way set a primary key to Auto Increment like you can
> with MySQL?

See the documentation on CREATE SEQUENCE, and also on CREATE TABLE and the
SERIAL type.

[An aside:  this is something definitely that qualifies as a frequently
asked question, as this is like the 4th time in a week this question has
been asked.  Would posting a FAQ list on a regular basis to the list be
helpful for things like this, like is done on the Perl newsgroups?]

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Hanson's Treatment of Time:
    There are never enough hours in a day, but always too many days
    before Saturday.


pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Auto Increment
Next
From: Anand Raman
Date:
Subject: Re: Tuning Database