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

From Mathias Göthberg
Subject How to make the key in table increase automatically?
Date
Msg-id 000f01c00df8$92989ea0$912cc6c3@1an
Whole thread Raw
Responses Re: How to make the key in table increase automatically?
List pgsql-novice
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
uniquenumber that is 1 higher than the previous row. 

Mathias






pgsql-novice by date:

Previous
From: Assefa Yewondwossen
Date:
Subject: Postgres on NT
Next
From: "Sherwin Daganato"
Date:
Subject: serial data type limit