Re: [GENERAL] alter integer field to serial integer primary key

2006-09-30 Thread Adrian Klaver
On Friday 29 September 2006 09:51 am, [EMAIL PROTECTED] 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 > > > ---

[GENERAL] alter integer field to serial integer primary key

2006-09-30 Thread 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 searc