Re: [GENERAL] Adding PK to Existing Table [RESOLVED]

2011-04-01 Thread Rich Shepard
On Fri, 1 Apr 2011, Raghavendra wrote: Try out this... alter table add primary key(column name); Raghavendra, Aha! I missed noticing that I need parentheses around the column name. Much thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Adding PK to Existing Table

2011-04-01 Thread Raghavendra
Try out this... alter table add primary key(column name); Best Regards, Raghavendra EnterpriseDB Corporation On Fri, Apr 1, 2011 at 9:09 PM, Rich Shepard wrote: > In -9.0.3 I used ALTER TABLE to replace a varchar() column with a bigint > column so it can be assigned as the table's primary k