Re: Location of index information - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Location of index information
Date
Msg-id 20051207233854.GA4728@winnie.fuhr.org
Whole thread Raw
In response to Location of index information  (Jim Beckstrom <jrbeckstrom@sbcglobal.net>)
List pgsql-novice
On Wed, Dec 07, 2005 at 03:25:57PM -0800, Jim Beckstrom wrote:
> If the table names in a database are in pg_class.relname, where
> are the associated indexes, or where is this documented?

Indexes have entries in various tables such as pg_class, pg_index,
and pg_attribute.  See "System Catalogs" in the documentation for
details; here's the latest version:

http://www.postgresql.org/docs/8.1/interactive/catalogs.html

If that doesn't help then please describe what information you're
after or what you're trying to do.

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Location of index information
Next
From: Jim Beckstrom
Date:
Subject: Re: Location of index information