Postgres Pro
Downloads
Home   >   mailing lists

Re: How to make the key in table increase automatically? - Mailing list pgsql-novice

From Anthony E . Greene
Subject Re: How to make the key in table increase automatically?
Date
Msg-id 20000828054101.A18437@cp5340
Whole thread Raw
In response to How to make the key in table increase automatically?  (Mathias Göthberg <s97math@student.informatik.gu.se>)
List pgsql-novice
Tree view 
On 24 Aug 2000 14:24 Mathias Göthberg wrote:
>How to make the key in a table increase automatically with 1 every time a
>new row is added?
>
>That is, when I add a new row with all attributes except the primary key,
I
>want the primary key in that row to have a unique number that is 1 higher
>than the previous row.

Use data type 'serial'.

--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
Linux. The choice of a GNU Generation. <http://www.linux.org/>

pgsql-novice by date:

Previous
From: "Dan Manczak"
Date:
Subject: total newbie: Compilation & Install
Next
From: "Dan Manczak"
Date:
Subject: Re: Postgres on NT