Re: Are Indices automatically generated for primary keys?

Clemens Eisserer <linuxhippy(at)gmail(dot)com> wrote:

> Are indices for columns marked with "PRIMARY KEY" automatically
> generated by postgresql, or do I have to do it manually?

If you look at the documentation page for CREATE TABLE, you'll see
the following:

| PostgreSQL automatically creates an index for each unique
| constraint and primary key constraint to enforce uniqueness. Thus,
| it is not necessary to create an index explicitly for primary key
| columns. (See CREATE INDEX for more information.)

http://www.postgresql.org/docs/current/interactive/sql-createtable.html

There's a lot of information on the page, but if you use your
browser to search for PRIMARY KEY within the page, it's not too hard
to find.

Also, if you create a primary key or a unique constraint on a table,
you should see a notice informing you of the creation of the index,
and its name.

-Kevin