From: | "Jose' Soares" <jose(at)sferacarta(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | psql \d command |
Date: | 1998-10-22 08:49:59 |
Message-ID: | 362EF1B6.68C25B@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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'
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 1998-10-22 08:50:17 | Re: [HACKERS] ACL's |
Previous Message | Jose' Soares | 1998-10-22 08:42:55 | psql's help |