> 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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026