Thread: improve table dumping

improve table dumping

From
"Christopher Kings-Lynne"
Date:
Hi,

This implements a new layout for psql's \d command and actually shows rule
definitions as well as names:

Indexes:
    "users_users_pkey" PRIMARY KEY btree (userid),
    "users_users_username_key" UNIQUE btree (username),
    "users_users_email_lower_idx" btree (lower(email)),
Foreign Key Constraints:
    "$1" FOREIGN KEY (referrer) REFERENCES users_users(userid) ON UPDATE NO
ACTION ON DELETE SET NULL
Rules:
    "test_rule" 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 it's an improvement - it make a lot more stuff just fit on the
screen, and is a lot easier to read!  I did also notice that pg_get_ruledef
appends a semicolon, whereas the other pg_get_* functions do not...

Chris

Attachment