How to find non-unique indexes in system tables

From: "Eric Johnson" <ericlj63(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to find non-unique indexes in system tables
Date: 2007-11-06 15:15:20
Message-ID: cbf217330711060715o28276e8arcde0048f9015448b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I can find all the check constraints, primary keys and foreign keys in
the information schema, but I cannot find the non-unique indexes. Is
there anyplace to get that information (name, columns, etc)?

Sorry if this is an FAQ. I couldn't find it with Google.

--

Eric Johnson

"Where your pleasure is, there is your treasure: where your treasure,
there your heart; where your heart, there your happiness."
Saint Augustine

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Schröder 2007-11-06 15:25:09 How does the query planner make its plan?
Previous Message Richard Huxton 2007-11-06 15:15:17 Re: Postgresql simple query performance question