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

Does an index get created for a Primary Key or is it just a constraint?

Thanks,
ThomasLL

_________________________________________________________________
Free up your inbox with MSN Hotmail Extra Storage. Multiple plans available.
http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/

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)