Re: Auto Increment

On Tue, 26 Dec 2000 postgres(at)flipper(dot)webdevelop(dot)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.