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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
