Re: [Fwd: Make psql use all pretty print options]

> Uh, I can't apply this to 7.4 unless you can get others to agree it
> should be added. Sorry.

OK, for reviewers. Note the index predicate and the check constraint in
particular.

With patch:

test=# \d example
Table "public.example"
Column | Type | Modifiers
--------+---------+--------------------------------------------------------
a | integer | not null default nextval('public.example_a_seq'::text)
b | integer |
c | integer |
d | boolean |
Indexes:
"example_pkey" PRIMARY KEY, btree (a)
"example_b_key" UNIQUE, btree (b)
"example_idx" btree (abs(a)) WHERE c > 11
Check constraints:
"example_d" CHECK (d)
Foreign-key constraints:
"$1" FOREIGN KEY (c) REFERENCES parent(a)
Rules:
example_rule AS
ON INSERT TO example DO INSTEAD NOTHING

Without patch:

test=# \d example
Table "public.example"
Column | Type | Modifiers
--------+---------+--------------------------------------------------------
a | integer | not null default nextval('public.example_a_seq'::text)
b | integer |
c | integer |
d | boolean |
Indexes:
"example_pkey" primary key, btree (a)
"example_b_key" unique, btree (b)
"example_idx" btree (abs(a)) WHERE (c > 11)
Check constraints:
"example_d" CHECK d
Foreign-key constraints:
"$1" FOREIGN KEY (c) REFERENCES parent(a)
Rules:
example_rule AS ON INSERT TO example DO INSTEAD NOTHING