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 <[EMAIL PROTECTED]>
To: Postgres <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED]
>Jarob Consulting [EMAIL PROTECTED]
>Provo, Utah [EMAIL PROTECTED]
