Re: Location of index information

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Location of index information
Дата
Msg-id 20051207233854.GA4728@winnie.fuhr.org
обсуждение исходный текст
Ответ на Location of index information  (Jim Beckstrom <jrbeckstrom@sbcglobal.net>)
Список 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 по дате отправления:

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: Location of index information
Следующее
От: Jim Beckstrom
Дата:
Сообщение: Re: Location of index information