Re: Showing index details with \d on psql

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Showing index details with \d on psql
Date: 2001-10-13 19:23:10
Message-ID: Pine.LNX.4.30.0110132043020.643-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-10-13 19:39:39 Re: psql: default base and password reading
Previous Message Peter Eisentraut 2001-10-13 18:14:40 Re: psql: default base and password reading