Re: How to find and/or REINDEX only GiST indexes in the database? - Mailing list pgsql-admin

"Gnanakumar" <gnanam@zoniac.com> wrote:

> how do I find out or REINDEX *only* GiST indexes in the
> database?  Is there a single syntax/command that does this?

I would probably capture the output from:

SELECT indexdef || ';'
  FROM pg_indexes
  WHERE indexdef ~ ' USING gist ';

-Kevin