Re: Location of index information

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jim Beckstrom <jrbeckstrom(at)sbcglobal(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Location of index information
Date: 2005-12-07 23:38:54
Message-ID: 20051207233854.GA4728@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jim Beckstrom 2005-12-08 03:53:56 Re: Location of index information
Previous Message Michael Glaesemann 2005-12-07 23:34:17 Re: Location of index information