Carol Walter <walterc(at)indiana(dot)edu> wrote:
> This may be a silly question but I don't see any place where the
> documentation explicitly addresses whether or not you can designate
> a particular column as a primary key after the table is created.
It sounds like you need ALTER TABLE DROP CONSTRAINT and ALTER TABLE
ADD table_constraint:
http://www.postgresql.org/docs/8.4/interactive/sql-altertable.html
-Kevin