new format for describe (repost #2) - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject new format for describe (repost #2)
Date
Msg-id 00f301c2e1f1$0aec6e30$6500a8c0@fhp.internal
Whole thread Raw
Responses Re: new format for describe (repost #2)
Re: new format for describe (repost #2)
List pgsql-patches
(This didnt' seem to get through the first two times :( )

Hi,

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

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)
Check Constraints:
    "users_users_sex" CHECK ((sex = 'M'::bpchar) OR (sex = 'F'::bpchar))
Foreign Key Constraints:
    "$1" FOREIGN KEY (referrer) REFERENCES users_users(userid) ON DELETE 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;
Triggers:
    "RI_ConstraintTrigger_1105134",
    "RI_ConstraintTrigger_1105135",
    "RI_ConstraintTrigger_1105138",
    "RI_ConstraintTrigger_1105139",
    "RI_ConstraintTrigger_1105396",
    "RI_ConstraintTrigger_1105397"

I think this is a massive improvement, and far more readable, compared to
this:

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)
Check constraints: "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
Rules: test_rule,
       test_rule2
Triggers: RI_ConstraintTrigger_1105134,
          RI_ConstraintTrigger_1105135,
          RI_ConstraintTrigger_1105138,
          RI_ConstraintTrigger_1105139,
          RI_ConstraintTrigger_1105396,
          RI_ConstraintTrigger_1105397

Shall I go ahead and tidy it up for submission?

I've also got 'pg_get_triggerdef' in the works so we can actually show
trigger definitions as well...

Chris




Attachment

pgsql-patches by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: psql patch for datestyle
Next
From: Tom Lane
Date:
Subject: Re: new format for describe (repost #2)