Postgres Pro
Downloads
Home   >   mailing lists

Thread: KEY or INDEX

KEY or INDEX

From
tövis
Date:
Hi All
Seem to be that I can not create KEY exclude PRIMARY and FOREIGN.
This means for one table I can create only one key.
All other, frequently used operations (browse, search) should use INDEX-es (may be unique).
Is these statemens are correct?
 
Best regards
    tövis
 

Re: KEY or INDEX

From
Bruno Wolff III
Date:
On Tue, May 03, 2005 at 11:57:31 +0200,
  tövis <tovises@freemail.hu> wrote:
> Hi All
> Seem to be that I can not create KEY exclude PRIMARY and FOREIGN.
> This means for one table I can create only one key.
> All other, frequently used operations (browse, search) should use INDEX-es (may be unique).
> Is these statemens are correct?

The FOREIGN KEY clause doesn't create keys.

You can use UNIQUE and NOT NULL clauses to create candidate keys.