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

From Tom Lane
Subject Re: How to find and/or REINDEX only GiST indexes in the database?
Date
Msg-id 13080.1318429272@sss.pgh.pa.us
Whole thread Raw
In response to How to find and/or REINDEX only GiST indexes in the database?  ("Gnanakumar" <gnanam@zoniac.com>)
List pgsql-admin
"Gnanakumar" <gnanam@zoniac.com> writes:
> My question is, how do I find out or REINDEX *only* GiST indexes in the
> database?  Is there a single syntax/command that does this?

You could do something like

select relname from pg_class where relam = (select oid from pg_am where amname = 'gist');


            regards, tom lane

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: How to find and/or REINDEX only GiST indexes in the database?
Next
From: "Kevin Grittner"
Date:
Subject: Re: How to find and/or REINDEX only GiST indexes in the database?