Re: Auto increment

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

use the 'serial' field type.

e.g.

create table hosts (
id serial,
ip char(16),
hostname text
);

insert into hosts (ip,hostname) values ('127.0.0.1','localhost');

-doug

ps - you also might want to use 'cidr' instead of char for the ip field.