Re: [HACKERS] psql \d command

> Hi all,
>
> I see now \d shows indexes, I tried to display index structure but it
> show the wrong
> length of fields:
>
> Table = figure
> +----------------------------------+----------------------------------+-------+
> | Field | Type |
> Length|
> +----------------------------------+----------------------------------+-------+
> | azienda | char() not null
> | 11 |
> | tipo | char() not null
> | 2 |
> | gruppo | char() not null
> | 2 |
> | inizio_attivita | date not null
> | 4 |
> | fine_attivita | date
> | 4 |
> | codice_figura | char() not null
> | 11 |
> +----------------------------------+----------------------------------+-------+
> Index: figure_pkey
> hygea=> \d figure_pkey
>
> Table = figure_pkey
> +----------------------------------+----------------------------------+-------+
> | Field | Type |
> Length|
> +----------------------------------+----------------------------------+-------+
> it should be:
> | azienda | char()
> | -4 |<<-- 11
> | tipo | char()
> | -4 |<<-- 02
> | gruppo | char()
> | -4 |<<-- 02
> | inizio_attivita | date
> | 4 |<<-- 04
> +----------------------------------+----------------------------------+-------+

Added to TODO:

* psql \d on index with char()/varchar() fields shows improper length

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026