Re: [Fwd: Make psql use all pretty print options]
От | Christopher Kings-Lynne |
---|---|
Тема | Re: [Fwd: Make psql use all pretty print options] |
Дата | |
Msg-id | 3F8638CA.7010209@familyhealth.com.au обсуждение исходный текст |
Ответ на | Re: [Fwd: Make psql use all pretty print options] (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
Re: [Fwd: Make psql use all pretty print options]
|
Список | pgsql-patches |
> 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
В списке pgsql-patches по дате отправления: