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
+----------------------------------+----------------------------------+-------+

Jose'


В списке pgsql-hackers по дате отправления:

Предыдущее
От: jwieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [HACKERS] What about LIMIT in SELECT ?
Следующее
От: "Jose' Soares"
Дата:
Сообщение: psql's help