PRIMARY KEY and INDEX - Mailing list pgsql-sql

From Nosyman
Subject PRIMARY KEY and INDEX
Date
Msg-id 200409021358.i82DwGQ8022806@acten.itcnet.ro
Whole thread Raw
Responses Re: PRIMARY KEY and INDEX
Re: PRIMARY KEY and INDEX
List 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)


pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: copy old column's values to new column
Next
From: Achilleus Mantzios
Date:
Subject: Re: PRIMARY KEY and INDEX