From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Auto increment |
Date: | 2003-05-27 18:21:32 |
Message-ID: | 200305271121.32959.scrawford@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
create sequence(foo_sequence);
create table foo (mysequence int not null default nextval('foo_sequence'),
somedata text);
See "create sequence" for options like start value and step. Note: sequences
are used to create unique values - not to create sequences without gaps. A
sequence number grabbed in a transaction that is rolled back will leave the
sequence incremented.
Cheers,
Steve
On Tuesday 27 May 2003 10:37 am, Fontenot, Paul wrote:
> When creating a table how do you make an auto incrementing field? I'm
> using:
>
> Create table hosts (
> id int not null unique primary key,
> ip char(16),
> hostname text
> );
>
> Is there a way to make the host.id field automagicaly increment?
>
> ***PRIVILEGED & CONFIDENTIAL***
> Unless expressly stated otherwise, this message (and any attachment(s)
> thereto) is confidential and may be privileged. It is intended for the
> addressee(s) only. If you are not an addressee, any disclosure or
> copying of the contents of this e-mail or any action taken (or not
> taken) in reliance on it is strictly prohibited. If you are not an
> addressee, please inform sender immediately and delete this message from
> your system.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Chad Thompson | 2003-05-27 18:35:29 | pg_dumpall and restore |
Previous Message | Doug Silver | 2003-05-27 18:18:27 | Re: Auto increment |