Re: How can I know whether an index already exists

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