Обсуждение: How can I know whether an index already exists

Hi there,
How can I know whether an index already exists?
I have googled for hours and cannot found the solution...
Any response are appreciated.

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

On 06/22/10 11:16 PM, kaifeng.zhu wrote:
> Hi there,
> How can I know whether an index already exists?
> I have googled for hours and cannot found the solution...
>

query this table,

http://www.postgresql.org/docs/current/static/catalog-pg-class.html

possibly joined with...

http://www.postgresql.org/docs/current/static/catalog-pg-index.html



or query this view,
http://www.postgresql.org/docs/current/static/view-pg-indexes.html

those are all in the pg_catalog schema, which is shared by all databases