Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-10-13 19:39:39
Subject: Re: psql: default base and password reading
Previous:From: Peter EisentrautDate: 2001-10-13 18:14:40
Subject: Re: psql: default base and password reading

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group