Re: new format for describe (repost #2)

Christopher Kings-Lynne writes:

> I have done up a new way of dumping table data:

Perhaps the visualisation could be improved even more if the data where
output in table form?

> Indexes:
>     "users_users_pkey" PRIMARY KEY btree (userid),
>     "users_users_username_key" UNIQUE btree (username),
>     "expiry_users_users_key" btree (expiry),
>     "users_users_email_lower_idx" btree (lower(email)),
>     "users_users_referrer_idx" btree (referrer),
>     "users_users_susp_off_idx" btree (suspended_off) WHERE (suspended_off IS NOT NULL)

                     Indexes
       Name       | Type  | Columns | Attributes
------------------+-------+---------+-------------
 users_users_pkey | btree | userid  | primary key
...

(To hell with vertical space ;-) )

> Check Constraints:
>     "users_users_sex" CHECK ((sex = 'M'::bpchar) OR (sex = 'F'::bpchar))

      Name       |                  Condition
-----------------+--------------------------------------------
 users_users_sex | (sex = 'M'::bpchar) OR (sex = 'F'::bpchar)

> Foreign Key Constraints:
>     "$1" FOREIGN KEY (referrer) REFERENCES users_users(userid) ON DELETE SET NULL

 Name | Referencing Col | Referenced Tbl | Referenced Col | Delete Action
------+-----------------+----------------+----------------+---------------...
 $1   | referrer        | users_users    | userid         | SET NULL

> Rules:
>     "test_rule" AS ON INSERT TO users_users DO INSTEAD NOTHING;,
>     "test_rule2" AS ON INSERT TO users_users DO INSTEAD NOTHING;

    Name   |    Table    | Event  |     Action
-----------+-------------+--------+-----------------
 test_rule | users_users | INSERT | INSTEAD NOTHING

--
Peter Eisentraut   peter_e@gmx.net