Re: Showing index details with \d on psql

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