Primary keys and indexes

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Primary keys and indexes
Date: 2005-01-21 20:54:36
Message-ID: 20050121205436.M57801@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

Does building a primary key constraint automatically generate an index? Using
pgadmin I cannot see it if it does. Should I explicitly build indexes on
primary keys? Wouldn't building a unique index on the same columns as the
primary key be redundent? Your guidance is appreciated.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-01-21 21:20:09 Re: Primary keys and indexes
Previous Message Márcio Vinícius 2005-01-21 18:41:06 BatchMove with PostgreSQL