Skip site navigation (1) Skip section navigation (2)

Re: Does an index get create for a Primary Key?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Thomas LeBlanc <thomasatiem(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Does an index get create for a Primary Key?
Date: 2004-03-31 22:52:13
Message-ID: 20040331225212.GO30378@dcc.uchile.cl (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-general
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)

In response to

pgsql-general by date

Next:From: Neil ConwayDate: 2004-03-31 23:13:37
Subject: Re: Best open source db poll currently
Previous:From: Bill MoranDate: 2004-03-31 22:42:43
Subject: Re: Wich hardware suits best for large full-text indexed

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group