psql \d command
От | Jose' Soares |
---|---|
Тема | psql \d command |
Дата | |
Msg-id | 362EF1B6.68C25B@sferacarta.com обсуждение исходный текст |
Ответы |
Re: [HACKERS] psql \d command
Re: [HACKERS] psql \d command |
Список | 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'
В списке pgsql-hackers по дате отправления: