On 6/11/07, Sabin Coanda <[EMAIL PROTECTED]> wrote:
I'd like to know when I create a primary key on a table, does postgres will
create automatically an index on that table related to the primary key
columns, or I have to create it explicitly ?
From http://www.postgresql.org/docs/8.2/static/indexes-unique.html :
"PostgreSQL automatically creates a unique index when a unique
constraint or a primary key is defined for a table. The index covers
the columns that make up the primary key or unique columns (a
multicolumn index, if appropriate), and is the mechanism that enforces
the constraint."
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
