Re: Create Primary Key? - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Create Primary Key?
Date
Msg-id Pine.BSF.4.10.10008291808340.57603-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Create Primary Key?  (Webb Sprague <wsprague100@yahoo.com>)
Responses Re: Create Primary Key?  (darcy@druid.net (D'Arcy J.M. Cain))
List pgsql-sql
We don't currently support the SQL syntax for adding
a PK to a table.  However, if you have the columns
as NOT NULL already, adding a unique index to the
columns in question has the same general effect.

Stephan Szabo
sszabo@bigpanda.com

On Tue, 29 Aug 2000, Webb Sprague wrote:

> Apropos of my last question:
> 
> Is there syntax to create a primary key after the
> table has been defined and populated?  I think I could
> speed things up quite a bit by not having any indexes
> at all when I do my mass copies.



pgsql-sql by date:

Previous
From: Webb Sprague
Date:
Subject: Create Primary Key?
Next
From: Jie Liang
Date:
Subject: Re: Optimizing huge inserts/copy's