Re: discovering an index definition

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: discovering an index definition
Дата
Msg-id 1022244536.631.9.camel@rebel
обсуждение исходный текст
Ответ на Re: discovering an index definition  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
On Thu, 2002-05-23 at 23:27, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
> > While "\d foo" will describe all of the fields and their
> > data types for the table foo, how do I do something similar
> > for an index?
>
> \d index

Thanks.  After scrounging around the system catalogs, I can
see why that is.

HOWEVER...  That it unintuitive in the extreme!  To Joe
Programmer, this is an index, not a table...

--
+---------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net     |
| Jefferson, LA  USA      http://ronandheather.dhs.org:81 |
|                                                         |
| "I have created a government of whirled peas..."        |
|   Maharishi Mahesh Yogi, 12-May-2002,                   |
!   CNN, Larry King Live                                  |
+---------------------------------------------------------+


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Pierre-Alexis PAQUIN"
Дата:
Сообщение: unsubscribe
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: script