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

From Tom Lane
Subject Re: Location of index information
Date
Msg-id 4613.1133998333@sss.pgh.pa.us
Whole thread Raw
In response to Location of index information  (Jim Beckstrom <jrbeckstrom@sbcglobal.net>)
Responses Re: Location of index information
List pgsql-novice
Jim Beckstrom <jrbeckstrom@sbcglobal.net> writes:
> If the table names in a database are in pg_class.relname, where are the associated indexes, or where is this
documented?

The indexes have their own entries in pg_class.  The linkage between a
table and its indexes is made through entries in pg_index.  See the
system catalogs documentation for your release:
http://www.postgresql.org/docs/8.1/static/catalogs.html
(adjust link as needed --- although the basic stuff tends to remain
the same across releases, sometimes the details change)

            regards, tom lane

pgsql-novice by date:

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