Postgres Pro
Downloads
Home   >   mailing lists

Re: Does an index get create for a Primary Key? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Does an index get create for a Primary Key?
Date
Msg-id 20040331225212.GO30378@dcc.uchile.cl
Whole thread Raw
In response to Does an index get create for a Primary Key?  ("Thomas LeBlanc" <thomasatiem@hotmail.com>)
List pgsql-general
Tree view 
On Wed, Mar 31, 2004 at 03:39:01PM -0600, Thomas LeBlanc wrote:
> Does an index get created for a Primary Key or is it just a constraint?

Yes, an unique btree index.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La Primavera ha venido. Nadie sabe como ha sido" (A. Machado)

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Wich hardware suits best for large full-text indexed
Next
From: "scott.marlowe"
Date:
Subject: Re: select distinct w/order by