Re: Auto Increment

I'm a Postgres newbie who used MySQL autoincrement functionality
too.  Here's what I found.

If you will create the column type as serial, postgres will
create a sequence and assign the default value for the serial
column to be the sequence.nextval() value.

or you can just create a sequence and upon insertion into the
column, insert the value of the column as sequence.nextval() yourself.

This works for me.  HTH.

-darrel

On Fri, 7 Jul 2000, Stephen Lawrence wrote:

> I am writing a small stamping program and was wondering: what is the best
> way to do auto incrementing. I use MySQL also, and it handles
> auto-incrementing, but postgresql does not.
>
> I am using the Perl-DBI interface.
>
> Thanks
> -
> Stephen Lawrence Jr.
> logart@dairypower.com
>
>