Postgres Pro
Downloads
Home   >   mailing lists

Re: create table autoincrement - Mailing list pgsql-general

From Brent R. Matzelle
Subject Re: create table autoincrement
Date
Msg-id 20010809135017.84097.qmail@web13004.mail.yahoo.com
Whole thread Raw
In response to create table autoincrement  (Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@ica.conti.de>)
List pgsql-general
Tree view 
--- Jose Manuel Lorenzo Lopez
<jose-manuel.lorenzo-lopez@ica.conti.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/

pgsql-general by date:

Previous
From: Jose Manuel Lorenzo Lopez
Date:
Subject: create table autoincrement
Next
From: Tom Lane
Date:
Subject: Re: An unfair comparision....