Re: Integrating the field auto-increment - Mailing list pgsql-general

From Dave Cramer
Subject Re: Integrating the field auto-increment
Date
Msg-id 1059731311.2140.154.camel@localhost.localdomain
Whole thread Raw
In response to Integrating the field auto-increment  (thomas.mathes@tmnd.de)
List pgsql-general
create table foo ( id serial )

Dave
On Fri, 2003-07-25 at 11:07, thomas.mathes@tmnd.de wrote:
> Hello,
>
> How can I implement an integer field with the autoincrement option ?
> That means I want to have a field, where every row has different values
> (unique) but this values should be generated automatically.
> Every new row has a new value, which is 1 higher than the old one.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Dave Cramer <dave@fastcrypt.com>
fastcrypt


pgsql-general by date:

Previous
From: "Chad Thompson"
Date:
Subject: Re: [SQL] ALTER TABLE ... DROP CONSTRAINT
Next
From: Francisco J Reyes
Date:
Subject: Re: comparing database schema's