Re: [GENERAL] auto increment?

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