Postgres Pro
Downloads
Home   >   mailing lists

Re: How to create primary key - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How to create primary key
Date
Msg-id 473030C1.6060702@iol.ie
Whole thread Raw
In response to How to create primary key  (Reg Me Please <regmeplease@gmail.com>)
Responses Re: How to create primary key  (Samantha Atkins <sjatkins@mac.com>)
List pgsql-general
Tree view 
On 06/11/2007 08:54, Reg Me Please wrote:

> What'd be the syntax to create a primary key on an already build table?

ALTER TABLE test ADD CONSTRAINT test_pk PRIMARY KEY (f1);

http://www.postgresql.org/docs/8.2/static/sql-altertable.html


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: Locale and indexes: howto?
Next
From: Samantha Atkins
Date:
Subject: Re: How to create primary key