Try using SERIAL: CREATE TABLE mytable ( MYID SERIAL, name TEXT );
It will auto create the sequences for you. Cory Wright [EMAIL PROTECTED] http://www.southcarrollton.net/ On Mon, 22 Oct 2001, Arian Prins wrote: > On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu" > <[EMAIL PROTECTED]> wrote: > > >hi all, > > > >could anyone tell me how to make a primary key to AUTO INCREMENT. The > >document is not exactly very explainatory about it :) > > > >Thankx in advance ... > > > > > > > >Mayuresh > > > > > > Try first creating a sequence and then using the sequence as a default > value in your table: > > > -- STEP 1: create sequence > create sequence mytableid_seq; > > -- STEP 2: create table > create table mytable ( > id int default nextval ('mytableid_seq'), > anyvalue varchar > primary key (id)); > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
