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(at)jrc-utah(dot)com>
> To: Postgres <pgsql-general(at)postgreSQL(dot)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(at)jrc-utah(dot)com
> >Jarob Consulting rwilliams(at)kde(dot)org
> >Provo, Utah rwilliams71(at)mailexcite(dot)com

--
Robert Williams rwilliams(at)jrc-utah(dot)com
Jarob Consulting rwilliams(at)kde(dot)org
Provo, Utah rwilliams71(at)mailexcite(dot)com