Re: Integrating the field auto-increment

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To: thomas(dot)mathes(at)tmnd(dot)de
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Integrating the field auto-increment
Date: 2003-08-01 09:48:31
Message-ID: 1059731311.2140.154.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

create table foo ( id serial )

Dave
On Fri, 2003-07-25 at 11:07, thomas(dot)mathes(at)tmnd(dot)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(at)fastcrypt(dot)com>
fastcrypt

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2003-08-01 09:52:19 Re: surppressing column names in COPY format
Previous Message Nico Latzer 2003-08-01 07:47:50 Re: owner cant delete from table, permission denied