Request a Demo
Home   >   mailing lists

Re: Selecting names of indexes that are not dependent on constraints. - Mailing list pgsql-sql

From Dmitriy Igrishin
Subject Re: Selecting names of indexes that are not dependent on constraints.
Date
Msg-id b4399d111003110720m4805d511pb468aefb0f3cd60c@mail.gmail.com
Whole thread Raw
In response to Selecting names of indexes that are not dependent on constraints.  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-sql
Tree view
Of course, I meant the indexes of which constraints do not depend. :)

2010/3/11 Dmitriy Igrishin <dmitigr@gmail.com>
Hey all,

How can I select names of indexes of table (or even whole schema) that are not dependent on constraints?

Unfortunately there is no way to select only "independent" indexes from pg_indexes view.

How can I do it?

Regards,
Dmitriy Igrishin

pgsql-sql by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Selecting names of indexes that are not dependent on constraints.
Next
From: Tom Lane
Date:
Subject: Re: Selecting names of indexes that are not dependent on constraints.