Re: Auto Increment

Try using SERIAL:

CREATE TABLE mytable (
MYID SERIAL,
name TEXT
);

It will auto create the sequences for you.

Cory Wright
corz(at)southcarrollton(dot)net
http://www.southcarrollton.net/
On Mon, 22 Oct 2001, Arian Prins wrote:

> On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu"
> <mayureshk(at)aftek(dot)com> 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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>