psql \d command

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'

Responses

Browse pgsql-hackers by date

  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