Re: [SQL] Autonumber column

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bron Till <bron(at)hit(dot)co(dot)nz>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Autonumber column
Date: 2000-01-06 01:32:38
Message-ID: 200001060132.UAA17085@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Sequences. See my book for a chapter on it on web site.

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> How can I create an autonumber (automatically incremented by 1) column in
> table in Postgres? Do I have to use a trigger?
>
>
>
> ************
>
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-06 01:47:04 Re: [SQL] Calculation dependencies in views
Previous Message Bron Till 2000-01-06 00:40:17 Autonumber column