On Tue, May 17, 2011 at 12:12 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> Well, the SERIAL pseudo-type creates the sequence, associates it with the
> column, and sets a DEFAULT on the column which executes the nextval()
> function on the sequence - all in one fell swoop. Read all about it here:
>
> http://www.postgresql.org/docs/9.0/static/datatype-numeric.html#DATATYPE-SERIAL
Wow I had no idea. So I do NOT need to manually create a sequence with:
CREATE SEQUENCE blah_id_seq;
And instead I can just use the SERIAL data type, unless I understood
that wrong. I'm going to read up on the URL you provided.
Thank you so much!
