Обсуждение: 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

That does the job.  Thank you.

Another related question:  I need to use /i file to import my
current database into postgres.  It seems that I have to use
nextval(...) when doing an insert.  Is it possible to insert a
row without having to use 'nextval()'?

David Hartwig wrote:
>
> 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

--
Robert Williams          rwilliams@jrc-utah.com
Jarob Consulting         rwilliams@kde.org
Provo, Utah              rwilliams71@mailexcite.com