[GENERAL] alter integer field to serial integer primary key

[rloefgren]

I have an integer field of unique, consecutive numbers. Can I change
this to be a serial, primary key field using an ALTER TABLE ALTER
COLUMN command? I haven't been able to stumble over it.

thanks,

r


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org