Postgres Pro
Downloads
Home   >   mailing lists

alter integer field to serial integer primary key - Mailing list pgsql-general

From rloefgren@forethought.net
Subject alter integer field to serial integer primary key
Date
Msg-id 1159548669.578342.177300@b28g2000cwb.googlegroups.com
Whole thread Raw
Responses Re: alter integer field to serial integer primary key
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David Cressey"
Date:
Subject: Re: cyclical redundancy checksum algorithm(s)?
Next
From: "sami"
Date:
Subject: dropdb cmd line args