Re: Location of index information

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Location of index information
Дата
Msg-id 4613.1133998333@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Location of index information  (Jim Beckstrom <jrbeckstrom@sbcglobal.net>)
Ответы Re: Location of index information  (Jim Beckstrom <jrbeckstrom@sbcglobal.net>)
Список 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 по дате отправления:

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