Postgres Pro
Downloads
Home   >   mailing lists

Is the primary key constraint also an index? - Mailing list pgsql-general

From Tim Uckun
Subject Is the primary key constraint also an index?
Date
Msg-id 855e4dcf0808121918u1d6b55cevcae057495f697e0a@mail.gmail.com
Whole thread Raw
Responses Re: Is the primary key constraint also an index?
Re: Is the primary key constraint also an index?
Re: Is the primary key constraint also an index?
List pgsql-general
Tree view 
If I have a primary key constraint defined in the database do I also
need to create an index on that field for fast lookup?

The documentation on the web seems to imply that the contraint is not
an index. Is that right?

What the difference between creating a unique, not null index and
setting a primary key?

Thanks.

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: How to modify ENUM datatypes? (The solution)
Next
From: "Dann Corbit"
Date:
Subject: Re: Is the primary key constraint also an index?