Re: Primary key on existing table?

Carol Walter <walterc@indiana.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