Primary keys and indexes - Mailing list pgsql-novice

From Keith Worthington
Subject Primary keys and indexes
Date
Msg-id 20050121205436.M57801@narrowpathinc.com
Whole thread Raw
Responses Re: Primary keys and indexes
List 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


pgsql-novice by date:

Previous
From: "Van Ingen, Lane"
Date:
Subject: Windows 8.0 Install Failure
Next
From: Bruno Wolff III
Date:
Subject: Re: Primary keys and indexes