On Friday 29 September 2006 09:51 am, rloefgren@xxxxxxxxxxxxxxx wrote: > 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 I think the easiest way would be to use CREATE SEQUENCE to create a sequence with a start value above that of max(integer field) and then use ALTER TABLE to set the nextval(sequence) as the DEFAULT value. -- Adrian Klaver aklaver@xxxxxxxxxxx
