Skip site navigation (1) Skip section navigation (2)

Re: autoincrement question

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Jack Albright <jack(at)mobiusnm(dot)com>, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: autoincrement question
Date: 2008-01-07 22:39:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
--- On Mon, 1/7/08, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:

> create table junktable (
>      pk1 serial primary key
> );
> will get you what you want.  Check out the docs for the
> "serial" column type.

Also, if the table and column already exist, you can alter the table's column to become an auto-incrementing column.

You can substitute the create table statement with an appropriate alter table alter column statement from the example demonstrated in the above link.

Richard Broersma Jr.

In response to


pgsql-novice by date

Next:From: Greg CocksDate: 2008-01-07 22:52:45
Subject: Re: autoincrement question
Previous:From: Sean DavisDate: 2008-01-07 21:12:36
Subject: Re: autoincrement question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group