This my be simpler than the answer you were after, but... If you're getting something like "cannot insert duplicate key into unique index fred", you could type: "\d fred" at a psql prompt to learn what column(s) fred refers to. You can learn even more by digging into the system tables, but I'll leave that version of the answer to the smarter folk.
-Nick > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Jodi Kanter > Sent: Monday, January 07, 2002 4:25 PM > To: Postgres Admin List > Subject: [ADMIN] unknown index > > > I am working with a database that was not created by our team. There are > some indexes set up on a table and I need to understand what type they are > and how they are functioning. > How can I look at this in Postgres? > I have a situation where we trying to update data and are > receiving an error > based on this index but I have no idea how it was set up. > Thanks > Jodi > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
