PRIMARY KEY and indexes

From: "Craig Bryden" <postgresql(at)bryden(dot)co(dot)za>
To: "pgsql" <pgsql-general(at)postgresql(dot)org>
Subject: PRIMARY KEY and indexes
Date: 2005-04-23 09:45:43
Message-ID: 000901c547e9$3873ea80$0200a8c0@amd2800
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I come from a MS-SQL background and I'm trying to get some clarity on
indexes in Postgres. If anyone can help with the following questions it
would be much appreciated:

1. When creating a primary key contraint on a table, is an equivalent index
automatically created for you, or would I have to create an index manually?
2. How do I create a clustered index in postgres?

Thanks
Craig

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2005-04-23 09:58:14 Re: UltraSPARC versus AMD
Previous Message Typing80wpm 2005-04-23 09:36:00 Article on PostgreSQL V8 release