Re: serial column

From: Gevik Babakhani <pgdev(at)xs4all(dot)nl>
To: Bob Pawley <rjpawley(at)shaw(dot)ca>
Cc: Postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: serial column
Date: 2006-09-24 21:00:54
Message-ID: 1159131654.726.2.camel@voyager.truesoftware.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2006-09-24 at 13:50 -0700, Bob Pawley wrote:
> I need to develop a serial column that always starts at 1 and is
> sequential even after deletes.
>
> Any ideas???
>

Did you try the:

create table tbl
(
id SERIAL
);

or even with primary key...

create table tbl
(
id SERIAL primary key
);

--
Regards,
Gevik Babakhani

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-09-24 21:19:10 Re: serial column
Previous Message Bob Pawley 2006-09-24 20:50:08 serial column