Re: Question about PostgreSQL Metadata

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lane Van Ingen" <lvaningen(at)esncc(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Question about PostgreSQL Metadata
Date: 2006-03-21 21:59:44
Message-ID: 2313.1142978384@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Lane Van Ingen" <lvaningen(at)esncc(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-03-23 02:04:44 Bytea and perl
Previous Message Lane Van Ingen 2006-03-21 21:49:37 Question about PostgreSQL Metadata