On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar <bghatkar@zedo.com> wrote: > Tom, > The query which you gave returns me 0 rows. > select ctid,xmin,xmax,* from pg_index where indexrelid in > (select indexrelid from pg_index group by 1 having count(*)>1); > Regards, > Bhakti
How about just select ctid,xmin,xmax,* from pg_index?