> -----Original Message----- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Wednesday, October 03, 2012 2:47 PM > To: Igor Neyman > Cc: Robert Sosinski; Merlin Moncure; pgsql-general@postgresql.org; > Spike Grobstein > Subject: Re: [GENERAL] Postgres will not start due to corrupt index > > Igor Neyman <iney...@perceptron.com> writes: > > I wonder if there is a column in pg catalog, that indicates the type > of the index. I couldn't find one. > > join relam to pg_am.oid > > > So, I ran the following sql trying to find system indexes of gin or > gist type: > > There aren't any. > > regards, tom lane
Tom, thank you. In this case: select i.indexname, a.amname, i.tablename from pg_indexes i JOIN (pg_class c join pg_am a ON (c.relam = a.oid) ) ON (i.indexname = c.relname) WHERE i.schemaname = 'pg_catalog'; Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
