Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding PK to Existing Table [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Adding PK to Existing Table [RESOLVED]
Date
Msg-id alpine.LNX.2.00.1104010925000.3160@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Adding PK to Existing Table  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Tree view 
On Fri, 1 Apr 2011, Raghavendra wrote:

> Try out this...
> alter table <table name> add primary key(column name);

Raghavendra,

   Aha! I missed noticing that I need parentheses around the column name.

Much thanks,

Rich

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: How to get index columns/dir/ord informations?
Next
From: George Woodring
Date:
Subject: Re: autovacuum issue after upgrade to 9.0.1