[GENERAL] How to trace index to table?

2006-10-02 Thread Chris Hoover 
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

Re: [GENERAL] How to trace index to table?

2006-10-02 Thread Ardian Xharra 



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


  - Original Message - 
  From: 
  Chris Hoover 
  
  To: pgsql-general@postgresql.org 
  
  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