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(at)gmx(dot)net