Horton

Re: psql's \d versus included-index-column feature

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Oleksandr Shulgin <oleksandr.shulgin@zalando.de>, Alexander Korotkov <a.korotkov@postgrespro.ru>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2018-07-19T15:44:10Z
Lists: pgsql-hackers 
On Thursday, July 19, 2018, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>
> > Given that the documentation refers to included columns as "non-key
> > columns", it seems natural to me to name the \d output column "Key?" and
> > use "yes/no" as the values.
>
> WFM, anyone want to argue against?
>

Works for me as well.

David J.

Commits

  1. Fix pg_get_indexdef()'s behavior for included index columns.

  2. Improve psql's \d command to show whether index columns are key columns.