[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] alter integer field to serial integer primary key
From:       Adrian Klaver <aklaver () comcast ! net>
Date:       2006-09-30 20:49:08
Message-ID: 200609301349.08403.aklaver () comcast ! net
[Download RAW message or body]

On Friday 29 September 2006 09:51 am, rloefgren@forethought.net 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@comcast.net

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]