Each PostgreSQL table has a, system assigned, oid (object ID) column which
is useful for uniquely identifying rows. Users have vertually no control
over it value.
There is also:
CREATE TABLE foo (
ai serial primary key,
bar integer
);
which is a short cut in the parser for:
CREATE SEQUENCE ai_seq;
CREATE TABLE foo (
ai integer default nextval('ai_seq') primary key,
bar integer
);
The ai column in each create statement does not require the user code to
explicitly assign its values.
See CREATE_SEQUENCE in the doc.
----- Original Message -----
From: Robert Williams <rwilliams@jrc-utah.com>
To: Postgres <pgsql-general@postgreSQL.org>
Sent: Saturday, January 23, 1999 4:11 PM
Subject: [GENERAL] auto increment?
>How do I set up a column as auto increment? I have looked
>everywhere for the postgres equivalent ROWID as in Oracle.
>
>--
>Robert Williams rwilliams@jrc-utah.com
>Jarob Consulting rwilliams@kde.org
>Provo, Utah rwilliams71@mailexcite.com