psql \d command
Jose Soares <jose@sferacarta.com>
From: "Jose' Soares" <jose@sferacarta.com>
To: pgsql-hackers@postgresql.org
Date: 1998-10-22T08:49:59Z
Lists: pgsql-hackers
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 +----------------------------------+----------------------------------+-------+ Jose'