Question about PostgreSQL Metadata - Mailing list pgsql-novice

From Lane Van Ingen
Subject Question about PostgreSQL Metadata
Date
Msg-id EKEMKEFLOMKDDLIALABIAEANCJAA.lvaningen@esncc.com
Whole thread Raw
Responses Re: Question about PostgreSQL Metadata
List pgsql-novice
I am using version 8.0.3 on Windows 2003.

I would like to get a report out of PostgreSQL like the one below, EXCEPT
that I would like to associate a table name with the indexes this query
pulls
from pg_class.

Does anyone know how to do this?

-------- report query -------------
select relname,
  relpages,
  reltuples,
  relpages,
  relnatts
  from pg_class
  where relkind = 'i'
  and relname not like 'sql_%'
  and relname not like 'pg_%'
order by 1;



pgsql-novice by date:

Previous
From: "Luis Silva"
Date:
Subject: Re: Trigger problem
Next
From: Tom Lane
Date:
Subject: Re: Question about PostgreSQL Metadata