Re: Showing index details with \d on psql - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: Showing index details with \d on psql
Date
Msg-id Pine.LNX.4.30.0110132043020.643-100000@peter.localdomain
Whole thread Raw
In response to Re: Showing index details with \d on psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-patches
Greg Sabino Mullane writes:

>                           Table "b1"
>  Column |           Type           |        Modifiers
> - --------+--------------------------+--------------------------
>  post   | integer                  | *
>  thread | smallint                 | not null *
>  reply  | smallint                 | not null *
>  stat   | character varying(1)     | not null default 'N' * *
>  uid    | integer                  | not null
>  ctime  | timestamp with time zone | default 'now'
>  atime  | timestamp with time zone |
> Indexes  abc (post, reply, stat)
>          def (stat)
>          foo_pkey [PRIMARY_KEY] (thread)

Please use "(primary key)" and add a colon after "Indexes".

I don't like the '*' things.  They look ugly and convey little real
information.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-patches by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql: default base and password reading
Next
From: "Serguei Mokhov"
Date:
Subject: Re: PG_DUMP NLS (Russian)