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
