Auto numbering column

Goren Amir · #1 (**permalink**) 07-22-09, 01:44

Hi,
How can I create a table with a column contains an auto numbering ( Auto ID column ) ?

Tnx.

bigcalm · #2 (**permalink**) 07-22-09, 03:49

you want a SERIAL column type.

eg.

create table dropme ( pk1 serial, hello char(20) );

create unique index i_dropme_1 on dropme (pk1);

alter table dropme add constraint primary key (pk1);

papajack · #3 (**permalink**) 10-08-09, 22:21

you can select rowid from tablename, rowid is unique.

Internet Services

Web Development

Digital Marketing

Consumer Tech