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.
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.
> Stephen Lawrence Jr.
In response to
pgsql-novice by date
|Next:||From: vincent.millet||Date: 2000-07-10 18:00:49|
|Subject: oidvector Error with initdb|
|Previous:||From: alias||Date: 2000-07-10 16:42:51|