Re: create table autoincrement

From: "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>
To: Jose Manuel Lorenzo Lopez <jose-manuel(dot)lorenzo-lopez(at)ica(dot)conti(dot)de>, Lista PGSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: create table autoincrement
Date: 2001-08-09 13:50:17
Message-ID: 20010809135017.84097.qmail@web13004.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- Jose Manuel Lorenzo Lopez
<jose-manuel(dot)lorenzo-lopez(at)ica(dot)conti(dot)de> wrote:
> Hello PG's,
>
> is it possible to create a table with key fields (integer)
> that will autoincrement
> when inserting a dataset???
>
> Thanks for your help in advance!

Try the SERIAL data type.

Brent

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-09 14:12:07 Re: An unfair comparision....
Previous Message Jose Manuel Lorenzo Lopez 2001-08-09 13:38:44 create table autoincrement