Re: primary key index

2007/5/14, Sim Zacks <sim@compulab.co.il>:

> I read the section on indexes where it says that PostGreSQL creates a unique
> index, but I didn't see an index on the table so I didn't know if it was implicit or if
> for some reason my primary keys weren't becoming indexes.

You are supposed to see those indexes. Try "\d tablename" in psql. It
should give you a bunch of information, including something like:

Indexes:
    "tablename_pkey" PRIMARY KEY, btree (keyfieldname)

Where tablename is your table's name, and keyfieldname the name of the
column that is your PK.

greetings,
Nicolas

--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachments.html