Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
alter integer field to serial integer primary key
- From: rloefgren(at)forethought(dot)net
- To: pgsql-general(at)postgresql(dot)org
- Subject: alter integer field to serial integer primary key
- Date: 29 Sep 2006 09:51:09 -0700
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
- Follow-Ups:
- Re: alter integer field to serial integer primary key
- From: Adrian Klaver
- Re: alter integer field to serial integer primary key
- Prev by Date: Re: Array assignment behavior (was Re: [ADMIN] Stored procedure array limits)
- Next by Date: Re: benchmark suite
- Previous by thread: Array assignment behavior (was Re: [ADMIN] Stored procedure array limits)
- Next by thread: Re: alter integer field to serial integer primary key
- Indexes: