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 <[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]
--
Robert Williams [EMAIL PROTECTED]
Jarob Consulting [EMAIL PROTECTED]
Provo, Utah [EMAIL PROTECTED]
begin:vcard
n:Williams;Robert
x-mozilla-html:TRUE
org:Jarob Consulting
adr:;;;Provo;UT;84604;USA
version:2.1
email;internet:[EMAIL PROTECTED]
title:Consultant
fn:Robert Williams
end:vcard
