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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
