On Fri, Jul 26, 2002 at 14:49:30 -0500,
Jim Steil <jim(dot)steil(at)customcall(dot)com> wrote:
> Is there a data type in PostgreSQL that will 'auto-increment'? I have used
> this in MS SQL Server in the past and would like to continue to do so with
> PostgreSQL. Thanks for any help...
You probably want to use sequences. There is even a psuedo type "serial"
that makes using them easier.
Note that sequences provide unique values, but they can skip over values.
Normally this is OK for keys, but if you really want a counter then
you need to do something different.
In response to
pgsql-novice by date
|Next:||From: Jillian Carroll||Date: 2002-07-29 16:14:32|
|Subject: Altering psqlodbc.h|
|Previous:||From: Wim||Date: 2002-07-29 12:58:35|
|Subject: Still problems with pg_dump ad \dt...|