Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I know whether an index already exists - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: How can I know whether an index already exists
Date
Msg-id AANLkTin9y0cJ6nLfLQ_XuAjvKt9ULb5mT6boq35nApFT@mail.gmail.com
Whole thread Raw
In response to How can I know whether an index already exists  ("kaifeng.zhu" <cafeeee@gmail.com>)
List pgsql-general
Tree view 
On 23 June 2010 10:16, kaifeng.zhu <cafeeee@gmail.com> wrote:
> Hi there,
> How can I know whether an index already exists?

SELECT *
FROM pg_indexes
WHERE indexname ~ 'your_indexname';


--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802

pgsql-general by date:

Previous
From: "kaifeng.zhu"
Date:
Subject: How can I know whether an index already exists
Next
From: John R Pierce
Date:
Subject: Re: How can I know whether an index already exists