Re: Showing index details with \d on psql

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Showing index details with \d on psql
Дата
Msg-id Pine.LNX.4.30.0110141358140.849-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Showing index details with \d on psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Showing index details with \d on psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Greg Sabino Mullane writes:

> > I don't like the '*' things.  They look ugly and convey little
> > real information.
>
> They convey "this column is indexed" and also indicate in how many
> indexes it appears.

I understood that, but a new user would not without a footnote.  And
obviously, '*' is just an arbitrary character -- what would we use next to
say "this column is part of a table constraint"?  I think this part is
very useful as it stands:

> Indexes: abc (post, reply, stat)
>          def (stat)
>          foo_pkey (primary key) (thread)

Hmm, shouldn't that be "foo_pkey(thread) (primary key)".  I understand
what you meant about the brackets, but brackets aren't typically used in
writing and look artificial.  Maybe something like

    foo_pkey (thread) -- primary key

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql: default base and password reading
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: psql: default base and password reading