Re: Noob question: how to auto-increment index field on INSERT?

Ken MacDonald wrote on 19.11.2009 17:55:
> Hi,
> I have a PostgreSQL DB created by a Django model, with a field 'id' that
> is automatically created by Django as a primary key, type integer.
>
> I would like to create a new row by doing something like....
>
> INSERT INTO table (a, b, c, d) VALUES ('aa', 'bb', 'cc', 'dd')
>
> where I've been hoping that 'id' would get the next value of id
> available. Unfortunately, instead I get a 'duplicate primary key' error
> saying that 'id' is a duplicate, even though I'm not specifying it
> explicitly in the INSERT. What is the proper way to auto-increment a
> primary key?

You should create the column with the datatype serial

Thomas