Re: [GENERAL] auto increment?

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