PRIMARY KEY and INDEX

From: "Nosyman" <nosyman(at)easymail(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: PRIMARY KEY and INDEX
Date: 2004-09-02 16:58:16
Message-ID: 200409021358.i82DwGQ8022806@acten.itcnet.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

It is necessary to define an index for a primary key column?

Let's have an example
CREATE TABLE users(
id_user INTEGER PRIMARY KEY,
user_name VARCHAR(25)
);

Does PgSQL automatically create an index for id_user (primary key) or it
must be created by hand?

Thanks

_________________________________________________________________
Message
sent using ITCNet free webmailer (http://www.easymail.ro)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message James M Doherty 2004-09-03 14:36:44 HOW TO HANDLE ZEROS IN DATE FIELD?
Previous Message Devrim GUNDUZ 2004-09-02 14:48:35 Re: PRIMARY KEY and INDEX