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

From Dave Cramer
Subject Re: Integrating the field auto-increment
Date
Msg-id 1059731722.2135.167.camel@localhost.localdomain
Whole thread Raw
In response to Integrating the field auto-increment  (thomas.mathes@tmnd.de)
Responses Re: Integrating the field auto-increment
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
--
Dave Cramer <Dave@micro-automation.net>


pgsql-general by date:

Previous
From: Nico Latzer
Date:
Subject: Re: owner cant delete from table, permission denied
Next
From: Dave Cramer
Date:
Subject: Re: surppressing column names in COPY format