| 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
| 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 |