Re: How to trace index to table?

"Ardian Xharra" <axharra@xxxxxxxxxx> · Mon, 2 Oct 2006 09:38:30 -0400

If you look on pg_indexes you find the index and 
the table.

  ----- Original Message ----- 
  From: 
  Chris Hoover 

  To: pgsql-general@xxxxxxxxxxxxxx 

  Sent: Monday, October 02, 2006 9:19 
  AM
  Subject: [GENERAL] How to trace index to 
  table?

I'm trying to build some queries to gather metrics on my PG 
  database.  When looking at pg_class and pulling a row that is an index, 
  how do I use sql to pull the table the index belongs 
  to?

Thanks,

Chris

No virus found in this incoming message.
Checked by AVG Free 
  Edition.
Version: 7.1.407 / Virus Database: 268.12.11/460 - Release Date: 
  01/10/2006