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
On 23 June 2010 10:16, kaifeng.zhu 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...@gmail
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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
