Re: serial column - Mailing list pgsql-general

From Gevik Babakhani
Subject Re: serial column
Date
Msg-id 1159131654.726.2.camel@voyager.truesoftware.net
Whole thread Raw
In response to serial column  (Bob Pawley <rjpawley@shaw.ca>)
List 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




pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: serial column
Next
From: Simon_Kelly@moh.govt.nz
Date:
Subject: Re: Table Inheritance / VARCHAR search question