Re: Noob question: how to auto-increment index field on INSERT? - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Noob question: how to auto-increment index field on INSERT?
Date
Msg-id he45eh$549$1@ger.gmane.org
Whole thread Raw
In response to Re: Noob question: how to auto-increment index field on INSERT?  (Ken MacDonald <drken567@gmail.com>)
List pgsql-novice
Ken MacDonald wrote on 19.11.2009 19:59:
> Thanks to all who replied so far. I agree that using the serial type
> would be ideal, and in fact set up a couple test DB's that way.
> Unfortunately, Django is auto-generating this field from its data
> models, and I don't seem to have much/any control over its type.
>
> Looking at pgadmin some more, it appears that column 'id' is set up with
> a default value of 'nextval('tablename_id_seq'::regclass)'.

Which is essentially what "serial" is: just a shorthand for the above construct

Thomas

pgsql-novice by date:

Previous
From: Ken MacDonald
Date:
Subject: Re: Noob question: how to auto-increment index field on INSERT?
Next
From: Jasen Betts
Date:
Subject: Re: My second PL/pgSQL function - minor problem