Re: Create Primary Key?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Webb Sprague <wsprague100(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Create Primary Key?
Date: 2000-08-30 01:10:23
Message-ID: Pine.BSF.4.10.10008291808340.57603-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bigpanda(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-08-30 01:39:50 Re: Optimizing huge inserts/copy's
Previous Message Timothy Covell 2000-08-30 00:41:41 HELP pg_proc is corrupted!