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'