2007/5/14, Sim Zacks <[EMAIL PROTECTED]>:
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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
