Re: Are Indices automatically generated for primary keys?

Clemens Eisserer  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