Re: Auto incrementing an integer

From: Philip Hallstrom <philip(at)adhesivemedia(dot)com>
To: Sylte <Sylte_(at)hotmail(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Auto incrementing an integer
Date: 2001-05-14 21:53:38
Message-ID: Pine.BSF.4.31.0105141453150.494-100000@oddjob.adhesivemedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Take a look at the SERIAL datatype as well as sequences (CREATE SEQUENCE,
NEXTVAL, CURRVAL).

good luck!

On Mon, 14 May 2001, Sylte wrote:

> How do I construct a datatype that autoincrement in postgreSQL?
>
> Thanks
> Sylte
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sylte 2001-05-14 21:55:51 Re: Auto incrementing an integer
Previous Message Thomas Swan 2001-05-14 21:27:34 Re: Auto incrementing an integer