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
>
>