Re: Question about PostgreSQL Metadata - Mailing list pgsql-novice

From Tom Lane
Subject Re: Question about PostgreSQL Metadata
Date
Msg-id 2313.1142978384@sss.pgh.pa.us
Whole thread Raw
In response to Question about PostgreSQL Metadata  ("Lane Van Ingen" <lvaningen@esncc.com>)
List pgsql-novice
"Lane Van Ingen" <lvaningen@esncc.com> writes:
> I would like to associate a table name with the indexes this query
> pulls from pg_class.

You have to join against pg_index and then back to pg_class.
See the system catalogs documentation for your PG version, eg
http://www.postgresql.org/docs/8.0/static/catalogs.html

            regards, tom lane

pgsql-novice by date:

Previous
From: "Lane Van Ingen"
Date:
Subject: Question about PostgreSQL Metadata
Next
From: Sean Davis
Date:
Subject: Bytea and perl