From: "Martin A. Marques" <martin@math.unl.edu.ar>
> Hi, I would like to know which are the properties of the SERIAL type.
> Is a column defined SERIAL a primary key?
>
> Saludos... :-)
Basically serial is NOT NULL with DEFAULT of nextval(some-sequence) and a
primary key index defined on it. In fact if you do a \d on the table
concerned, that's what it'll say.
It's really just shorthand to save typing
- Richard Huxton