Re: create table autoincrement

From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Lista PGSQL" <pgsql-general(at)postgresql(dot)org>, "Jose Manuel Lorenzo Lopez" <jose-manuel(dot)lorenzo-lopez(at)ica(dot)conti(dot)de>
Subject: Re: create table autoincrement
Date: 2001-08-09 14:19:07
Message-ID: 007e01c120de$42077ca0$1001a8c0@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: "Jose Manuel Lorenzo Lopez" <jose-manuel(dot)lorenzo-lopez(at)ica(dot)conti(dot)de>

> Hello PG's,
>
> is it possible to create a table with key fields (integer) that will
autoincrement
> when inserting a dataset???
>
Look in the manuals for the CREATE SEQUENCE stuff. There is a special type
SERIAL which does all this for you. Check Bruce's online book too - bound to
have examples in that.

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2001-08-09 14:48:18 Re: An unfair comparision....
Previous Message Tom Lane 2001-08-09 14:12:07 Re: An unfair comparision....