Horton

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

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-07-18T20:26:32Z
Lists: pgsql-hackers 
On 2018-Jul-18, David G. Johnston wrote:

> ​-1 for printing a boolean t/f; would rather spell it out:
> 
> CASE WHEN "Key" THEN 'Key' ELSE 'Included' END AS "Data"

+1

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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.