Re: Location of index information
| От | Jim Beckstrom |
|---|---|
| Тема | Re: Location of index information |
| Дата | |
| Msg-id | 20051208035356.65655.qmail@web81608.mail.mud.yahoo.com обсуждение исходный текст |
| Ответ на | Re: Location of index information (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Location of index information
Re: Location of index information |
| Список | pgsql-novice |
Now that I have read the glossary for pg_index (thank you for the link), there wouldn't be a php function available to do the selection of all of the indexes for a table, would there?
Jim
Tom Lane <tgl@sss.pgh.pa.us> wrote:
Jim
Tom Lane <tgl@sss.pgh.pa.us> wrote:
Jim Beckstrom 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 detail s change)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
В списке pgsql-novice по дате отправления: