Re: create table autoincrement - Mailing list pgsql-general

From Richard Huxton
Subject Re: create table autoincrement
Date
Msg-id 007e01c120de$42077ca0$1001a8c0@archonet.com
Whole thread Raw
In response to create table autoincrement  (Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@ica.conti.de>)
List pgsql-general
From: "Jose Manuel Lorenzo Lopez" <jose-manuel.lorenzo-lopez@ica.conti.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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: An unfair comparision....
Next
From: Justin Clift
Date:
Subject: Re: An unfair comparision....