Thread: Re: Auto Increment

On Mon, 22 Oct 2001 12:06:21 +0530, "Mayuresh Kadu"
<mayureshk@aftek.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));

Try using SERIAL:

CREATE TABLE mytable ( MYID SERIAL, name TEXT
);

It will auto create the sequences for you.




Cory Wright
corz@southcarrollton.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@aftek.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>