Re: Showing index details with \d on psql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

Done and done. I capitalized and used brackets to make it
stand out more from the index contents, but it is now changed
back.

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

They convey "this column is indexed" and also indicate in how many
indexes it appears.

Anyway, revised patch attached.

Revised sample output:

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)

Greg Sabino Mullane
greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200110131806

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iQA/AwUBO8i8YrybkGcUlkrIEQI1ngCcCtzjcBB8hMrBsAh+wbSsExJCpUYAoP4E
FWCa51FCDi1BP8zTgdujnDlu
=4P3T
-----END PGP SIGNATURE-----