Carol Walter <walterc@xxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin